Posted On: Sep 28, 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 Amazon Lambda and Amazon AppSync. Redshift Data API simplifies data access, ingest, and egress from languages supported with Amazon 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 Amazon Secrets Manager, you don’t need to pass credentials in API calls. For customers using Amazon 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 Amazon 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 documentation. 

The Data API is available in all public Amazon Web Services regions, including the Amazon Web Services China (Beijing) Region, operated by Sinnet and the Amazon Web Services China (Ningxia) Region, operated by NWCD. 

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.