aid: amazon-redshift name: Amazon Redshift description: Amazon Redshift is a fast, 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. deliveryModel: model: saas open_source: false commercial: true callable_host: true label: Hosted service · you call their endpoint confidence: high source: - openapi - pricing generated: '2026-08-28' method: derived accessModel: pricing: paid onboarding: self-serve trial: true try_now: true public: false label: Paid (free trial) · Self-serve signup confidence: high source: - plans - authentication generated: '2026-07-22' method: derived image: https://a0.awsstatic.com/libra-css/images/logos/aws_logo_smile_1200x630.png url: https://raw.githubusercontent.com/api-evangelist/amazon-redshift/refs/heads/main/apis.yml created: '2024-01-01' modified: '2026-09-16' specificationVersion: '0.23' tags: - Analytics - Big Data - Cloud - Data Lake - Data Warehouse - ETL - Machine Learning - Serverless - SQL tags_raw: - Analytics - Big Data - Cloud - Data Lake - Data Warehouse - ETL - Machine Learning - Serverless - SQL - Machine-Learning apis: - name: Amazon Redshift Serverless API description: >- The Amazon Redshift Serverless API for managing serverless data warehouse workgroups, namespaces, and capacity without provisioning clusters. image: https://a0.awsstatic.com/libra-css/images/logos/aws_logo_smile_1200x630.png humanURL: https://docs.aws.amazon.com/redshift/latest/mgmt/serverless-whatis.html baseURL: https://redshift-serverless.amazonaws.com tags: - Data Warehouse - Namespaces - Serverless - Workgroups properties: - type: Documentation url: https://docs.aws.amazon.com/redshift/latest/mgmt/working-with-serverless.html - type: APIReference url: https://docs.aws.amazon.com/redshift-serverless/latest/APIReference/Welcome.html - type: SDKs url: >- https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/redshift-serverless.html title: Python SDK - type: SDKs url: https://docs.aws.amazon.com/AWSJavaScriptSDK/v3/latest/client/redshift-serverless/ title: JavaScript SDK - type: CLI url: https://docs.aws.amazon.com/cli/latest/reference/redshift-serverless/ - type: GettingStarted url: https://docs.aws.amazon.com/redshift/latest/mgmt/serverless-whatis.html - type: Pricing url: https://aws.amazon.com/redshift/pricing/ - aid: amazon-redshift:amazon-redshift-metadata-api name: Amazon Redshift Metadata API description: List databases, schemas, and tables in a Redshift data warehouse humanURL: https://aws.amazon.com/redshift/ baseURL: https://redshift.amazonaws.com tags: - Metadata properties: - type: OpenAPI url: openapi/amazon-redshift-metadata-api-openapi.yml - type: Documentation url: https://docs.aws.amazon.com/redshift/ - type: APIReference url: https://docs.aws.amazon.com/redshift/latest/APIReference/Welcome.html - type: GettingStarted url: https://docs.aws.amazon.com/redshift/latest/gsg/getting-started.html - type: Pricing url: https://aws.amazon.com/redshift/pricing/ - type: Console url: https://console.aws.amazon.com/redshift/ - type: SDKs url: https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/redshift.html - type: SDKs url: https://docs.aws.amazon.com/AWSJavaScriptSDK/v3/latest/client/redshift/ - type: CLI url: https://docs.aws.amazon.com/cli/latest/reference/redshift/ - type: BestPractices url: https://docs.aws.amazon.com/redshift/latest/dg/best-practices.html - type: Security url: https://docs.aws.amazon.com/redshift/latest/mgmt/security.html - type: FAQ url: https://aws.amazon.com/redshift/faqs/ - type: ReleaseNotes url: https://docs.aws.amazon.com/redshift/latest/mgmt/cluster-versions.html - type: ChangeLog url: https://docs.aws.amazon.com/redshift/latest/mgmt/document-history.html - type: Documentation url: https://docs.aws.amazon.com/redshift/latest/mgmt/data-api.html - type: APIReference url: https://docs.aws.amazon.com/redshift-data/latest/APIReference/Welcome.html - type: SDKs url: >- https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/redshift-data.html - type: SDKs url: https://docs.aws.amazon.com/AWSJavaScriptSDK/v3/latest/client/redshift-data/ - type: CLI url: https://docs.aws.amazon.com/cli/latest/reference/redshift-data/ - type: GettingStarted url: https://aws.amazon.com/blogs/big-data/get-started-with-the-amazon-redshift-data-api/ - aid: amazon-redshift:amazon-redshift-result-retrieval-api name: Amazon Redshift Result Retrieval API description: Retrieve results from completed SQL statement executions humanURL: https://aws.amazon.com/redshift/ baseURL: https://redshift.amazonaws.com tags: - Result Retrieval properties: - type: OpenAPI url: openapi/amazon-redshift-result-retrieval-api-openapi.yml - type: Documentation url: https://docs.aws.amazon.com/redshift/ - type: APIReference url: https://docs.aws.amazon.com/redshift/latest/APIReference/Welcome.html - type: GettingStarted url: https://docs.aws.amazon.com/redshift/latest/gsg/getting-started.html - type: Pricing url: https://aws.amazon.com/redshift/pricing/ - type: Console url: https://console.aws.amazon.com/redshift/ - type: SDKs url: https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/redshift.html - type: SDKs url: https://docs.aws.amazon.com/AWSJavaScriptSDK/v3/latest/client/redshift/ - type: CLI url: https://docs.aws.amazon.com/cli/latest/reference/redshift/ - type: BestPractices url: https://docs.aws.amazon.com/redshift/latest/dg/best-practices.html - type: Security url: https://docs.aws.amazon.com/redshift/latest/mgmt/security.html - type: FAQ url: https://aws.amazon.com/redshift/faqs/ - type: ReleaseNotes url: https://docs.aws.amazon.com/redshift/latest/mgmt/cluster-versions.html - type: ChangeLog url: https://docs.aws.amazon.com/redshift/latest/mgmt/document-history.html - type: Documentation url: https://docs.aws.amazon.com/redshift/latest/mgmt/data-api.html - type: APIReference url: https://docs.aws.amazon.com/redshift-data/latest/APIReference/Welcome.html - type: SDKs url: >- https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/redshift-data.html - type: SDKs url: https://docs.aws.amazon.com/AWSJavaScriptSDK/v3/latest/client/redshift-data/ - type: CLI url: https://docs.aws.amazon.com/cli/latest/reference/redshift-data/ - type: GettingStarted url: https://aws.amazon.com/blogs/big-data/get-started-with-the-amazon-redshift-data-api/ - aid: amazon-redshift:amazon-redshift-statement-execution-api name: Amazon Redshift Statement Execution API description: Execute SQL statements against Amazon Redshift clusters or serverless workgroups humanURL: https://aws.amazon.com/redshift/ baseURL: https://redshift.amazonaws.com tags: - Statement Execution properties: - type: OpenAPI url: openapi/amazon-redshift-statement-execution-api-openapi.yml - type: Documentation url: https://docs.aws.amazon.com/redshift/ - type: APIReference url: https://docs.aws.amazon.com/redshift/latest/APIReference/Welcome.html - type: GettingStarted url: https://docs.aws.amazon.com/redshift/latest/gsg/getting-started.html - type: Pricing url: https://aws.amazon.com/redshift/pricing/ - type: Console url: https://console.aws.amazon.com/redshift/ - type: SDKs url: https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/redshift.html - type: SDKs url: https://docs.aws.amazon.com/AWSJavaScriptSDK/v3/latest/client/redshift/ - type: CLI url: https://docs.aws.amazon.com/cli/latest/reference/redshift/ - type: BestPractices url: https://docs.aws.amazon.com/redshift/latest/dg/best-practices.html - type: Security url: https://docs.aws.amazon.com/redshift/latest/mgmt/security.html - type: FAQ url: https://aws.amazon.com/redshift/faqs/ - type: ReleaseNotes url: https://docs.aws.amazon.com/redshift/latest/mgmt/cluster-versions.html - type: ChangeLog url: https://docs.aws.amazon.com/redshift/latest/mgmt/document-history.html - type: Documentation url: https://docs.aws.amazon.com/redshift/latest/mgmt/data-api.html - type: APIReference url: https://docs.aws.amazon.com/redshift-data/latest/APIReference/Welcome.html - type: SDKs url: >- https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/redshift-data.html - type: SDKs url: https://docs.aws.amazon.com/AWSJavaScriptSDK/v3/latest/client/redshift-data/ - type: CLI url: https://docs.aws.amazon.com/cli/latest/reference/redshift-data/ - type: GettingStarted url: https://aws.amazon.com/blogs/big-data/get-started-with-the-amazon-redshift-data-api/ - aid: amazon-redshift:amazon-redshift-statement-management-api name: Amazon Redshift Statement Management API description: Describe, list, and cancel SQL statement executions humanURL: https://aws.amazon.com/redshift/ baseURL: https://redshift.amazonaws.com tags: - Statement Management properties: - type: OpenAPI url: openapi/amazon-redshift-statement-management-api-openapi.yml - type: Documentation url: https://docs.aws.amazon.com/redshift/ - type: APIReference url: https://docs.aws.amazon.com/redshift/latest/APIReference/Welcome.html - type: GettingStarted url: https://docs.aws.amazon.com/redshift/latest/gsg/getting-started.html - type: Pricing url: https://aws.amazon.com/redshift/pricing/ - type: Console url: https://console.aws.amazon.com/redshift/ - type: SDKs url: https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/redshift.html - type: SDKs url: https://docs.aws.amazon.com/AWSJavaScriptSDK/v3/latest/client/redshift/ - type: CLI url: https://docs.aws.amazon.com/cli/latest/reference/redshift/ - type: BestPractices url: https://docs.aws.amazon.com/redshift/latest/dg/best-practices.html - type: Security url: https://docs.aws.amazon.com/redshift/latest/mgmt/security.html - type: FAQ url: https://aws.amazon.com/redshift/faqs/ - type: ReleaseNotes url: https://docs.aws.amazon.com/redshift/latest/mgmt/cluster-versions.html - type: ChangeLog url: https://docs.aws.amazon.com/redshift/latest/mgmt/document-history.html - type: Documentation url: https://docs.aws.amazon.com/redshift/latest/mgmt/data-api.html - type: APIReference url: https://docs.aws.amazon.com/redshift-data/latest/APIReference/Welcome.html - type: SDKs url: >- https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/redshift-data.html - type: SDKs url: https://docs.aws.amazon.com/AWSJavaScriptSDK/v3/latest/client/redshift-data/ - type: CLI url: https://docs.aws.amazon.com/cli/latest/reference/redshift-data/ - type: GettingStarted url: https://aws.amazon.com/blogs/big-data/get-started-with-the-amazon-redshift-data-api/ - aid: amazon-redshift:amazon-redshift-amazon-redshift-api name: Amazon Redshift Amazon Redshift API description: The Amazon Redshift API from Amazon Redshift — 119 operation(s) for amazon redshift. humanURL: https://docs.aws.amazon.com/redshift/latest/mgmt/serverless-whatis.html baseURL: https://redshift-serverless.amazonaws.com tags: - Amazon Redshift properties: - type: OpenAPI url: openapi/amazon-redshift-amazon-redshift-api-openapi.yml - type: Documentation url: https://docs.aws.amazon.com/redshift/latest/APIReference/Welcome.html - type: Documentation url: https://docs.aws.amazon.com/redshift-data/latest/APIReference/Welcome.html common: - type: CapabilityMap url: capabilities/amazon-redshift-capability-edges.yml name: Amazon Redshift Business Capability Map - type: RateLimits url: rate-limits/amazon-redshift-rate-limits.yml - type: FinOps url: finops/amazon-redshift-finops.yml - type: Plans url: plans/amazon-redshift-plans-pricing.yml - type: Website url: https://aws.amazon.com/redshift/ - type: PostmanWorkspace url: https://www.postman.com/kinlaneapi/amazon-redshift/overview - type: AgenticAccess url: agentic-access/amazon-redshift-agentic-access.yml - type: TrustCenter url: security/amazon-redshift-trust-center.yml - type: VulnerabilityDisclosure url: security/amazon-redshift-vulnerability-disclosure.yml - type: DomainSecurity url: security/amazon-redshift-domain-security.yml - type: Authentication url: authentication/amazon-redshift-authentication.yml - type: Blog url: https://aws.amazon.com/blogs/big-data/category/database/amazon-redshift/ - type: Support url: https://aws.amazon.com/premiumsupport/ - type: TermsOfService url: https://aws.amazon.com/service-terms/ - type: PrivacyPolicy url: https://aws.amazon.com/privacy/ - type: Documentation url: https://docs.aws.amazon.com/redshift/ - type: GettingStarted url: https://aws.amazon.com/redshift/getting-started/ - type: FAQ url: https://aws.amazon.com/redshift/faqs/ - type: Pricing url: https://aws.amazon.com/redshift/pricing/ - type: Console url: https://console.aws.amazon.com/redshift/ - type: StatusPage url: https://status.aws.amazon.com/ - type: Features data: - name: Massively Parallel Processing description: Distributed query execution across multiple nodes for petabyte-scale analytics with sub-second response times. - name: Serverless Data Warehouse description: Auto-scaling compute capacity without cluster provisioning, paying only for compute used during queries. - name: Data API description: Run SQL statements without managing database connections using IAM-based authentication and asynchronous execution. - name: Federated Query description: Query data across Amazon RDS, Aurora, and S3 data lakes without moving data using federated query capabilities. - name: Machine Learning Integration description: Build, train, and deploy ML models directly in Redshift using SQL with Amazon SageMaker integration. - name: Concurrency Scaling description: Automatically add transient capacity to handle bursts of concurrent queries without performance degradation. - type: UseCases data: - name: Business Intelligence Analytics description: Run complex analytical queries across petabytes of structured data for BI dashboards and reporting. - name: Data Lake Analytics description: Query data directly in Amazon S3 using Redshift Spectrum without loading it into the warehouse. - name: Real-Time Analytics description: Ingest streaming data and run near-real-time analytics on operational data for instant insights. - name: ETL Pipeline Processing description: Transform and load large datasets using SQL-based ETL operations within the data warehouse. - name: Serverless Ad-Hoc Queries description: Run on-demand analytical queries without provisioning clusters using Redshift Serverless and Data API. - type: Integrations data: - name: Amazon S3 description: Load data from and query data in S3 using COPY commands, Redshift Spectrum, and data lake integration. - name: AWS Glue description: Automated ETL job orchestration and data catalog integration for data warehouse loading. - name: Amazon QuickSight description: Connect QuickSight directly to Redshift for serverless BI dashboards and visualizations. - name: AWS Lambda description: Trigger Lambda functions from Redshift Data API results for event-driven data processing workflows. - name: Terraform description: Provision and manage Redshift clusters and serverless workgroups using Terraform infrastructure-as-code. - type: Integrations url: https://aws.amazon.com/partners/ integrations: - name: Partner Programs - name: Resources - name: Success Stories - name: Work with an AWS Partner - name: AWS Marketplace - name: AWS Partner Central - name: Partner Paths - name: co-sell with AWS maintainers: - FN: Kin Lane email: kin@apievangelist.com url: https://apievangelist.com x-parent: amazon-web-services x-relationship: product