How AI is applied across API Evangelist and APIs.io. Read my AI disclosure →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

Need help?

Contact us
Amazon Redshift

Amazon Redshift Metadata API

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

Documentation Provider Profile APIs.io OpenAPI GitHub

Amazon Redshift Metadata API is one of 5 APIs that Amazon Redshift publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

Tagged areas include Metadata. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, an API reference, a getting-started guide, pricing, and best-practice docs.

This API exposes 4 operations across 4 paths, and defines 12 schemas. It is described by OpenAPI 3.2.0, at version 2019-12-20.

Requests are made against a single base URL, https://redshift-data.{region}.amazonaws.com.

4 operations 4 paths 12 schemas 4 POST

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.2.0
API Version
2019-12-20
Base URL
https://redshift.amazonaws.com
Authentication
API Key
Contact
Amazon Web Services
License
Apache 2.0
Terms of Service
View terms
Resource Areas
1

Authentication & Security 1

Amazon Redshift Metadata API declares 1 security scheme for authenticating requests. An API key is passed in the header as Authorization (sigv4Auth). By default, every request must be authenticated.

  • sigv4Auth — AWS Signature Version 4 authentication. Requests are signed using IAM credentials. The Data API also supports authentication via AWS Secrets Manager for databa…

Paths & Operations 4

Across 4 paths, the API surfaces 4 operations — 4 POST. Each is listed below with its method, path, parameters, and response codes.

Metadata 4

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

POST
/ListDatabases
Amazon Redshift List Databases in a Cluster or Workgroup
listDatabases body → 200400500
POST
/ListSchemas
Amazon Redshift List Schemas in a Database
listSchemas body → 200400500
POST
/ListTables
Amazon Redshift List Tables in a Schema
listTables body → 200400500
POST
/DescribeTable
Amazon Redshift Describe the Columns of a Table
describeTable body → 200400500

Schemas 12

The contract defines 12 schemas that model the data the API accepts and returns. The most detailed are ColumnMetadata (13 properties), ListTablesRequest (9 properties), DescribeTableRequest (9 properties), ListSchemasRequest (8 properties). Each schema is shown below with its type and property counts.

DescribeTableResponse
object
3 properties
ColumnMetadata
object
13 properties
ValidationException
object
1 property
ListDatabasesRequest
object
7 properties 1 required
ListTablesResponse
object
2 properties
InternalServerException
object
1 property
ListDatabasesResponse
object
2 properties
ListSchemasRequest
object
8 properties 1 required
TableMember
object
3 properties
ListTablesRequest
object
9 properties 1 required
ListSchemasResponse
object
2 properties
DescribeTableRequest
object
9 properties 1 required

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

amazon-redshift-metadata-api-openapi.yml Raw ↑

Other APIs Amazon Redshift publishes across the network.

Amazon Redshift Serverless API
AE Profile APIs.io
Amazon Redshift Result Retrieval API
AE Profile APIs.io
Amazon Redshift Statement Execution API
AE Profile APIs.io
Amazon Redshift Statement Management API
AE Profile APIs.io
#Metadata
← Back to A APIs
API Details
ID
amazon-redshift:amazon-redshift-metadata-api
Base URL
https://redshift.amazonaws.com
Docs
https://aws.amazon.com/redshift/
Provider
Amazon Redshift
APIs.io →  GitHub →
Explore more
All APIs Providers APIs.io Network
Work with this as data

Every API here is available over the API and to AI agents over MCP. APIs is not yet its own endpoint on the v1 API. Reach this content through network search and the tag graph, or the MCP server below.

Installs https://mcp.apievangelist.com/mcp in Claude, Cursor, VS Code and the rest — one button, every client.

MCP tools for apis
4 tools reach this content
  • search_api_evangelistSearch every content type across the network at once.
  • find_relatedThe shared-tag relevance graph — what else covers this.
  • get_tagEverything one tag labels, across all content types.
  • guide_topicPRO — a curated bundle for a topic: area, guidance, rules, papers, stories, services.
All tools & prompts
Call it yourself
curl for this page
Search the network for this 
curl "https://api.apievangelist.com/v1/search?q=amazon-redshift-metadata-api&limit=10"
Everything under a tag 
curl "https://api.apievangelist.com/v1/tags/amazon-redshift-metadata-api"

Discovery needs no key. Full bodies and the synthesis endpoints are Pro.

Get an API key

Free tier, no email required. Sign in with whichever identity you already have.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have. Your account

Where this information came from

This is an independent, third-party profile of Amazon Redshift Metadata API, published by API Evangelist. We do not operate, host, resell, or support these APIs, and we are not affiliated with or endorsed by the company unless stated above. Everything here is built from publicly available information — the company's own site, developer portal, documentation, public repositories, and the specifications it publishes for public use. Nothing is obtained by breaching a system, defeating an access control, or using credentials.

The Kin Score and Agent Readiness rating are independently calculated assessments of a company's public API artifacts, scored against a published rubric. They are not certifications, endorsements, security assessments, or audits.

Corrections, re-scores, and removal are free — no partnership or purchase required, and you do not need to justify the request. A removed company is recorded as unrated, never scored zero for having asked. Acknowledgement within one business day; removal within two.

info@apievangelist.com · Read the full data-sourcing policy →
On a security or compliance team? Put security in the subject line and you will get a person, not a form — we will tell you exactly which public URLs this profile was built from.