Posted On: Sep 10, 2020
Amazon Redshift can now be accessed using the built-in Data API, making it easy to build web-services based applications and integrating with services, including AWS Lambda, AWS AppSync, and AWS Cloud9. Redshift Data API simplifies data access, ingest, and egress from languages supported with AWS SDK such as Python, Go, Java, Node.js, PHP, Ruby, and C++ so you can focus on building applications versus managing infrastructure.
The Data API simplifies access to Amazon Redshift by removing the need to manage database connections and credentials. Instead, you can execute SQL commands to an Amazon Redshift cluster by simply invoking an HTTPS API endpoint provided by the Data API. The Data API takes care of managing database connections and returning data. The Data API stores your query results for 24 hours and is asynchronous so you can retrieve your results later.
Since the Data API leverages IAM user credentials or database credentials stored in AWS Secrets Manager, you don’t need to pass credentials in API calls. For 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 VPC. Integration with the AWS SDK provides a programmatic interface to execute SQL statements with parameters. For more information, including instructions on getting started with Data API, please read the Amazon Redshift documentation or watch this demo.
The Data API is available in all AWS regions except AWS GovCloud (US) and Asia Pacific (Osaka) Local Region.
Amazon 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 Business Intelligence (BI) tools. Tens of thousands of customers use Amazon Redshift to process Exabytes of data per day and power analytics workloads. For more information, please visit the Amazon Redshift product page, and view the Amazon Redshift pricing page to get started.