
With the Data API, you can run individual queries from your application or submit a batch of SQL statements within a transaction, which is useful to simplify your workload. Therefore, you can use any language supported by the AWS SDK to build your application with it, such as C++, Go, Java, JavaScript. The Data API integrates with the AWS SDK to run queries. Use different programming language of your choice In this section, we discuss the key features of the Data API. Event-driven extract, load, transformation.Access Amazon Redshift with REST endpoints.Access Amazon Redshift from SageMaker Jupyter notebooks.Access Amazon Redshift from applications.Extract, transform, and load (ETL) orchestration with AWS Step Functions.

The Data API was launched in September 2020, and thousands of our customers are already using it for a variety of use cases:
REDSHIFT DATA API HOW TO
In this post, we learn how to get started with the Data API in different languages and also discuss various use cases in which customers are using this to build modern applications combining modular, serverless, and event-driven architectures.

In an earlier, post, we shared in great detail on how you can use the Data API to interact with your Amazon Redshift data warehouse. You can also perform federated queries with external data sources such as Amazon Aurora. The Data API also enables you to run analytical queries on Amazon Redshift’s native tables, external tables in your data lake via Amazon Redshift Spectrum, and also across Amazon Redshift clusters, which is known as data sharing. This allows you to build cloud-native, containerized, serverless, web-based, and event-driven applications on the AWS Cloud. With the Data API, you can programmatically access data in your Amazon Redshift cluster from different AWS services such as AWS Lambda, Amazon SageMaker notebooks, AWS Cloud9, and also your on-premises applications using the AWS SDK. Integrating Web Services and Serverless Applications using Amazon Redshift Data API.Since you’re reading this post, you may also be interested in the following AWS Online Tech Talks video for more info:
REDSHIFT DATA API SOFTWARE
You can run SQL statements using the AWS Software Development Kit (AWS SDK), which supports different languages such as C++, Go, Java, JavaScript.

The Amazon Redshift Data API is an Amazon Redshift feature that simplifies access to your Amazon Redshift data warehouse by removing the need to manage database drivers, connections, network configurations, data buffering, credentials, and more. Tens of thousands of customers use Amazon Redshift to process exabytes of data to power their analytical workloads. Amazon Redshift is a fast, scalable, secure, and fully managed cloud data warehouse that enables you to analyze your data at scale.
