Posted On: Mar 30, 2021

You can now use the Amazon Redshift Data API in the AWS GovCloud (US) Regions to access Amazon Redshift. The 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.