Amazon Redshift

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.
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-05-19'
specificationVersion: '0.19'
tags:
- Analytics
- Big Data
- Cloud
- Data Lake
- Data Warehouse
- ETL
- Machine Learning
- Serverless
- SQL
apis:
- name: Amazon Redshift API
  description: The Amazon Redshift API for managing clusters, snapshots, and configurations.
  image: https://a0.awsstatic.com/libra-css/images/logos/aws_logo_smile_1200x630.png
  humanURL: https://aws.amazon.com/redshift/
  baseURL: https://redshift.amazonaws.com
  tags:
  - Clusters
  - Data Warehouse
  - Snapshots
  properties:
  - type: Documentation
    url: https://docs.aws.amazon.com/redshift/
  - type: OpenAPI
    url: https://api.apis.guru/v2/specs/amazonaws.com/redshift/2012-12-01/openapi.yaml
  - 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: SDK
    url: https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/redshift.html
    title: Python SDK
  - type: SDK
    url: https://docs.aws.amazon.com/AWSJavaScriptSDK/v3/latest/client/redshift/
    title: JavaScript SDK
  - 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
- name: Amazon Redshift Data API
  description: The Amazon Redshift Data API for running SQL statements without managing connections. Supports asynchronous
    execution with IAM and Secrets Manager authentication.
  image: https://a0.awsstatic.com/libra-css/images/logos/aws_logo_smile_1200x630.png
  humanURL: https://docs.aws.amazon.com/redshift/latest/mgmt/data-api.html
  baseURL: https://redshift-data.amazonaws.com
  tags:
  - Data API
  - Serverless
  - SQL
  properties:
  - 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: OpenAPI
    url: openapi/amazon-redshift-data-api-openapi.yml
  - type: SDK
    url: https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/redshift-data.html
    title: Python SDK
  - type: SDK
    url: https://docs.aws.amazon.com/AWSJavaScriptSDK/v3/latest/client/redshift-data/
    title: JavaScript SDK
  - 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/
  - type: NaftikoCapability
    url: capabilities/data-metadata.yaml
  - type: NaftikoCapability
    url: capabilities/data-result-retrieval.yaml
  - type: NaftikoCapability
    url: capabilities/data-statement-execution.yaml
  - type: NaftikoCapability
    url: capabilities/data-statement-management.yaml
- 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: SDK
    url: https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/redshift-serverless.html
    title: Python SDK
  - type: SDK
    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/
common:
- 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: [email protected]
  url: https://apievangelist.com