The Universal API for Amazon Redshift provides a standardized interface to interact with Redshift clusters. Using this API, you can securely authenticate and execute SQL queries, including SELECT, INSERT, UPDATE, and DELETE operations, without handling the underlying database connection details. Leveraging OAuth 2.0 for authentication, the API allows developers to focus on analytics, reporting, and application logic while simplifying database interactions and ensuring secure, reliable access to Amazon Redshift data.
POST – API for Amazon Redshift Database
The Universal API for Amazon Redshift provides a single interface to securely interact with Redshift databases. You can execute SQL queries including SELECT, INSERT, UPDATE, and DELETE without worrying about connection details.
POST Token
{{base_url}}/token
This endpoint is used to retrieve an authentication token from the API. The token serves as an authorization mechanism to access and interact with the various API endpoints.
Body (form-data)
- username: {{Username}}
- password: {{Password}}
Endpoint:
{{base_url}}/universalAPI?db_name=Amazon Red Shift&db_version=All
Authorization
OAuth 2.0
Query Parameters
- db_name: Amazon Red Shift
- db_version: All
Body (raw JSON)
{
"username": "{{username}}",
"password": "{{password}}",
"query": "{{SELECT/INSERT QUERY}}",
"schema_name": "{{schema_name}}",
"hostname": "{{host_name}}",
"portnumber": {{port_number}}
}
