A financial services company stores financial data in Amazon Redshift. A data engineer wants to run real-time queries on the financial data to…

The Amazon Redshift Data API provides a secure, serverless HTTP endpoint to run SQL queries against an Amazon Redshift cluster. This is the optimal solution for a web-based application because it eliminates the need to configure JDBC/ODBC drivers and manage persistent database connections from the application tier. By using the Data API, the application can execute queries via simple API calls, which AWS manages, scales, and secures. This approach directly meets the requirements for real-time queries from a web application with the least operational overhead.

1. Amazon Redshift Documentation

"Using the Amazon Redshift Data API": "You can use the Amazon Redshift Data API to work with Amazon Redshift. [...] We recommend that you use the Data API for use cases where you want to call Amazon Redshift with an AWS SDK

for example from AWS Lambda functions and from Amazon SageMaker notebooks. [...] The Data API simplifies data access

and you don't need to configure a driver and manage database connections."

2. Amazon Redshift Documentation

"Overview of the Amazon Redshift Data API": "The Amazon Redshift Data API doesn't require a persistent connection to the cluster. Instead

it provides a secure HTTP endpoint and integration with AWS SDKs. You can use the endpoint to run SQL statements without needing to manage connections. Calls to the Data API are asynchronous." This highlights the reduction in operational overhead for applications like web services.

3. Amazon Redshift Documentation

"Configuring a JDBC connection": This document details the multi-step process of downloading the correct driver

configuring the connection URL with cluster details

and managing credentials

illustrating the higher operational overhead compared to the Data API. (Found in the Amazon Redshift Cluster Management Guide).