AWS Redshift

aid: aws-redshift
name: AWS Redshift
description: Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse service that makes it simple and cost-effective
  to analyze all your data using standard SQL and existing Business Intelligence tools.
type: Index
image: https://kinlane-productions.s3.amazonaws.com/apis-json/apis-json-logo.jpg
tags:
- Analytics
- Big Data
- Cloud Database
- Data Warehouse
- SQL
url: https://raw.githubusercontent.com/api-evangelist/aws-redshift/refs/heads/main/apis.yml
created: '2024-01-01'
modified: '2026-05-19'
specificationVersion: '0.19'
apis:
- aid: aws-redshift:amazon-redshift-api
  name: Amazon Redshift API
  description: The Amazon Redshift API provides programmatic access to create and manage Amazon Redshift clusters and their
    associated resources including snapshots, parameter groups, subnet groups, and reserved nodes.
  humanURL: https://aws.amazon.com/redshift/
  baseURL: https://redshift.{region}.amazonaws.com
  tags:
  - Clusters
  - Data Warehouse
  - Snapshots
  properties:
  - type: Documentation
    url: https://docs.aws.amazon.com/redshift/latest/APIReference/Welcome.html
  - type: OpenAPI
    url: openapi/aws-redshift-openapi.json
  - type: NaftikoCapability
    url: capabilities/aws-redshift.yaml
- aid: aws-redshift:amazon-redshift-data-api
  name: Amazon Redshift Data API
  description: The Amazon Redshift Data API enables you to run SQL statements without managing connections via a secure HTTP
    endpoint. It supports both synchronous and asynchronous SQL execution against Redshift clusters and Redshift Serverless
    workgroups.
  humanURL: https://docs.aws.amazon.com/redshift/latest/mgmt/data-api.html
  baseURL: https://redshift-data.{region}.amazonaws.com
  tags:
  - Data Access
  - Serverless
  - SQL
  properties:
  - type: Documentation
    url: https://docs.aws.amazon.com/redshift-data/latest/APIReference/Welcome.html
  - type: OpenAPI
    url: openapi/aws-redshift-data-openapi.json
  - type: NaftikoCapability
    url: capabilities/data.yaml
- aid: aws-redshift:amazon-redshift-serverless-api
  name: Amazon Redshift Serverless API
  description: API for Amazon Redshift Serverless, which makes it easy to run analytics workloads without managing data warehouse
    infrastructure. Automatically provisions and scales data warehouse capacity on demand.
  humanURL: https://aws.amazon.com/redshift/redshift-serverless/
  baseURL: https://redshift-serverless.{region}.amazonaws.com
  tags:
  - Analytics
  - Auto-Scaling
  - Serverless
  properties:
  - type: Documentation
    url: https://docs.aws.amazon.com/redshift-serverless/latest/APIReference/Welcome.html
common:
- type: Website
  url: https://aws.amazon.com/redshift/
- type: TermsOfService
  url: https://aws.amazon.com/service-terms/
- type: PrivacyPolicy
  url: https://aws.amazon.com/privacy/
- type: Support
  url: https://aws.amazon.com/premiumsupport/
- type: Blog
  url: https://aws.amazon.com/blogs/big-data/category/database/amazon-redshift/
- type: ChangeLog
  url: https://aws.amazon.com/releasenotes/Amazon-Redshift/
- type: StatusPage
  url: https://health.aws.amazon.com/health/status
- type: Pricing
  url: https://aws.amazon.com/redshift/pricing/
- type: GettingStarted
  url: https://docs.aws.amazon.com/redshift/latest/gsg/getting-started.html
- type: Documentation
  url: https://docs.aws.amazon.com/redshift/
- type: SpectralRules
  url: rules/aws-redshift-spectral-rules.yml
- type: Vocabulary
  url: vocabulary/aws-redshift-vocabulary.yaml
- type: Features
  data:
  - name: Petabyte-Scale Storage
    description: Store and query petabytes of structured and semi-structured data with columnar storage.
  - name: Standard SQL Support
    description: Query data using standard SQL and connect with existing BI tools via JDBC/ODBC.
  - name: Massively Parallel Processing
    description: Distribute SQL operations across multiple nodes for high-performance query execution.
  - name: Columnar Storage
    description: Store data in columnar format for efficient analytical query performance and compression.
  - name: Automated Snapshots
    description: Automated and manual snapshots for point-in-time recovery of your cluster data.
  - name: Data Sharing
    description: Share live data across Redshift clusters and accounts without copying data.
  - name: ML Integration
    description: Run Amazon Redshift ML to create, train, and deploy machine learning models using SQL.
  - name: Serverless Mode
    description: Run analytics workloads without managing cluster infrastructure with Redshift Serverless.
  - name: Federated Query
    description: Query data across operational databases, data warehouses, and data lakes.
  - name: AQUA
    description: Advanced Query Accelerator for up to 10x faster query performance using distributed hardware-accelerated
      cache.
- type: UseCases
  data:
  - name: Business Intelligence
    description: Power BI dashboards and reports with fast analytical queries over large datasets.
  - name: Log Analytics
    description: Analyze application logs and clickstream data for operational insights.
  - name: Financial Analytics
    description: Process financial transactions and generate regulatory reports over historical data.
  - name: Data Lake Analytics
    description: Query data in Amazon S3 data lakes using Redshift Spectrum without loading.
  - name: Machine Learning
    description: Build and deploy ML models directly within the warehouse using SQL with Redshift ML.
- type: Integrations
  data:
  - name: Amazon S3
    description: Load data from S3 and query data lake files using Redshift Spectrum.
  - name: Amazon Glue
    description: Catalog and ETL data into Redshift from various data sources.
  - name: Amazon QuickSight
    description: Connect QuickSight for BI visualization directly to Redshift.
  - name: AWS Lake Formation
    description: Manage fine-grained data access controls across Redshift and S3.
  - name: Amazon SageMaker
    description: Export training data and import ML model results from SageMaker.
  - name: dbt
    description: Transform data in Redshift using dbt data transformation framework.
  - name: Tableau
    description: Connect Tableau via JDBC/ODBC for interactive data visualization.
- type: Integrations
  url: https://aws.amazon.com/marketplace
integrations:
- name: Sign in
- name: Agent Mode
- name: Why AWS Marketplace?
- name: Get started in AWS Marketplace
- name: Industry
- name: Resources
- name: Become a Channel Partner
- name: Sell in AWS Marketplace
- name: Manage Your Account
maintainers:
- FN: Kin Lane
  email: [email protected]