Amazon Redshift

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.

Amazon Redshift publishes 4 APIs on the APIs.io network, including Metadata API, Result Retrieval API, Statement Execution API, and 1 more. Tagged areas include Analytics, Big Data, Cloud, Data Lake, and Data Warehouse.

The Amazon Redshift catalog on APIs.io includes 2 JSON-LD contexts and 2 Spectral governance rulesets.

Amazon Redshift’s developer surface includes authentication, engineering blog, support, documentation, getting-started guide, FAQ, pricing, and 9 more developer resources.

🌐 Visit website 📡 Source on GitHub

61.5/100 strong ▬ flat Agent 38/100 agent ready Full breakdown ↓
scored 2026-07-28 · rubric v0.6

AccessPaidSelf serveFree trial⚡ Free to try

5 APIs 6 Features 5 Use Cases

AnalyticsBig DataCloudData LakeData WarehouseETLMachine LearningServerlessSQL

Kin Score

Kin Score How this is scored →
scored 2026-07-28 · rubric v0.6

Composite quality — 61.5/100 · strong

Contract Quality 16.5 / 25

Developer Ergonomics 9.6 / 20

Commercial Clarity 15.8 / 20

Operational Transparency 6.2 / 13

Governance 7.0 / 12

Discoverability 6.5 / 10

Agent readiness — 38/100 · agent ready

Machine-Readable Contract 18 / 18

Agentic Access Contract 10 / 10

MCP Server 0 / 12

Machine-Readable Auth 10 / 10

Idempotency 0 / 9

Stable Error Semantics 8 / 8

Request/Response Examples 0 / 7

Rate-Limit Signaling 7 / 7

Typed Event Surface 0 / 6

Agent Skills 0 / 5

Well-Known Catalog 0 / 4

Consent & Bot Identity 0 / 3

A2A Agent Card 0 / 8

Dry-Run / Simulate Mode 0 / 4

Improve this rating by publishing the missing artifacts — every area above can be raised, and the full rubric is at apis.io/rating/. This rating is computed from github.com/api-evangelist/amazon-redshift: open an issue to ask a question, or submit a pull request to add artifacts. Want it done for you? Prioritized profiling — $2,500 →

APIs 5

Individual APIs this provider publishes, each with its own machine-readable definition.

Amazon Redshift Serverless API

The Amazon Redshift Serverless API for managing serverless data warehouse workgroups, namespaces, and capacity without provisioning clusters.

Amazon Redshift Metadata API

List databases, schemas, and tables in a Redshift data warehouse

Amazon Redshift Result Retrieval API

Retrieve results from completed SQL statement executions

Amazon Redshift Statement Execution API

Execute SQL statements against Amazon Redshift clusters or serverless workgroups

Amazon Redshift Statement Management API

Describe, list, and cancel SQL statement executions

Postman Collections 4

Ready-to-run Postman collections for exercising this provider's APIs.

Amazon Redshift Data Metadata API

POSTMAN

Amazon Redshift Data Metadata Result Retrieval API

POSTMAN

Amazon Redshift Data Metadata Statement Execution API

POSTMAN

Amazon Redshift Data Metadata Statement Management API

POSTMAN

Open Collections 1

Open, tool-agnostic API collections (OpenAPI-derived and Bruno).

Amazon Redshift Data API

OPEN COLLECTION

Pricing Plans 1

Published pricing tiers and plan structures.

Amazon Redshift Plans Pricing

3 plans

PLANS

Rate Limits 1

Documented rate limits and quota policies.

Amazon Redshift Rate Limits

5 limits

RATE LIMITS

FinOps 1

Cost, billing, and metering signals for API financial operations.

Amazon Redshift Finops

FINOPS

Features 6

Notable capabilities this provider offers.

Massively Parallel Processing

Distributed query execution across multiple nodes for petabyte-scale analytics with sub-second response times.

Serverless Data Warehouse

Auto-scaling compute capacity without cluster provisioning, paying only for compute used during queries.

Data API

Run SQL statements without managing database connections using IAM-based authentication and asynchronous execution.

Federated Query

Query data across Amazon RDS, Aurora, and S3 data lakes without moving data using federated query capabilities.

Machine Learning Integration

Build, train, and deploy ML models directly in Redshift using SQL with Amazon SageMaker integration.

Concurrency Scaling

Automatically add transient capacity to handle bursts of concurrent queries without performance degradation.

JSON Schema 31

Standalone JSON Schema definitions for this provider's data models.

Scroll for all 31

JSON Structure 30

JSON Structure definitions describing this provider's data shapes.

Scroll for all 30

Examples 30

Example request and response payloads for these APIs.

Scroll for all 30

Use Cases 5

What developers build with this provider.

Business Intelligence Analytics

Run complex analytical queries across petabytes of structured data for BI dashboards and reporting.

Data Lake Analytics

Query data directly in Amazon S3 using Redshift Spectrum without loading it into the warehouse.

Real-Time Analytics

Ingest streaming data and run near-real-time analytics on operational data for instant insights.

ETL Pipeline Processing

Transform and load large datasets using SQL-based ETL operations within the data warehouse.

Serverless Ad-Hoc Queries

Run on-demand analytical queries without provisioning clusters using Redshift Serverless and Data API.

Resources

Get Started 2

Portal, sign-up, and the first successful call

GettingStarted

GettingStarted

Console

Console

Documentation 1

Reference material describing how the API behaves

Documentation

Documentation

Agent Surfaces 1

MCP servers, agent skills, and machine-readable catalogs

AgenticAccess

AgenticAccess

Build 1

SDKs, sample code, and the tooling you integrate with

PostmanWorkspace

PostmanWorkspace

Access & Security 4

Authentication, authorization, and security posture

TrustCenter

TrustCenter

VulnerabilityDisclosure

VulnerabilityDisclosure

DomainSecurity

DomainSecurity

Authentication

Authentication

Operate 3

Status, limits, changes, and where to get help

Support

Support

FAQ

FAQ

StatusPage

StatusPage

Commercial 3

Pricing, plans, and the legal terms of use

TermsOfService

TermsOfService

PrivacyPolicy

PrivacyPolicy

Pricing

Pricing

Company 1

The organization behind the API

Blog

Blog

Source (apis.yml)

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.
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-05-19'
specificationVersion: '0.19'
tags:
- Analytics
- Big Data
- Cloud
- Data Lake
- Data Warehouse
- ETL
- Machine Learning
- Serverless
- SQL
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/
common:
- 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

Amazon Redshift

APIs 5

Postman Collections 4

Open Collections 1

Pricing Plans 1

Rate Limits 1

FinOps 1

Features 6

Massively Parallel Processing

Serverless Data Warehouse

Data API

Federated Query

Machine Learning Integration

Concurrency Scaling

Semantic Vocabularies 2

Spectral Rules 2

JSON Schema 31

JSON Structure 30

Examples 30

Security Posture 4

Agentic Access 1

Use Cases 5

Business Intelligence Analytics

Data Lake Analytics

Real-Time Analytics

ETL Pipeline Processing

Serverless Ad-Hoc Queries