![]() ![]() ![]() The Data API federates AWS Identity and Access Management (IAM) credentials so you can use identity providers like Okta or Azure Active Directory or database credentials stored in Secrets Manager without passing database credentials in API calls.įor customers using AWS Lambda, the Data API provides a secure way to access your database without the additional overhead for Lambda functions to be launched in an Amazon Virtual Private Cloud (Amazon VPC). Your query results are stored for 24 hours. The Data API is asynchronous, so you can retrieve your results later. The Data API takes care of managing database connections and buffering data. Instead, you can run SQL commands to an Amazon Redshift cluster by simply calling a secured API endpoint provided by the Data API. The Data API simplifies access to Amazon Redshift by eliminating the need for configuring drivers and managing database connections. ![]() The Amazon Redshift Data API simplifies data access, ingest, and egress from programming languages and platforms supported by the AWS SDK such as Python, Go, Java, Node.js, PHP, Ruby, and C++. The following diagram illustrates this architecture. The Amazon Redshift Data API enables you to painlessly access data from Amazon Redshift with all types of traditional, cloud-native, and containerized, serverless web service-based applications and event-driven applications. We also explain how to use AWS Secrets Manager to store and retrieve credentials for the Data API. This post explains how to use the Amazon Redshift Data API from the AWS Command Line Interface (AWS CLI) and Python. This makes it easier and more secure to work with Amazon Redshift and opens up new use cases. With Amazon Redshift Data API, you can interact with Amazon Redshift without having to configure JDBC or ODBC. Tens of thousands of customers use Amazon Redshift to process exabytes of data per day and power analytics workloads such as BI, predictive analytics, and real-time streaming analytics.Īs a data engineer or application developer, for some use cases, you want to interact with Amazon Redshift to load or query data with a simple API endpoint without having to manage persistent connections. July 2021: This post was reviewed and updated to include multi-statement and parameterization support.Īmazon Redshift is a fast, scalable, secure, and fully managed cloud data warehouse that makes it simple and cost-effective to analyze all your data using standard SQL and your existing ETL (extract, transform, and load), business intelligence (BI), and reporting tools. June 2023: This post was reviewed and updated for accuracy. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |