AWS Redshift Integration
Connect an Amazon Redshift cluster to Metaustral and automatically discover schemas, tables, views, and columns.
Prerequisites
- An Amazon Redshift cluster (provisioned or Redshift Serverless) with a publicly accessible endpoint, or network access via VPC peering / AWS PrivateLink.
- A database user with
SELECToninformation_schema.tablesandinformation_schema.columns. - Port
5439open in the cluster's security group to allow inbound connections from Metaustral. - Starter, Pro, or Enterprise plan.
How to connect
Open Integrations and click + New connection
Select Amazon Redshift as the type
Fill in the connection details
Enter a name, the cluster endpoint (host), port (default 5439), database name, username, and password. Add an optional schema filter to limit discovery to specific schemas.
Save and import metadata
Go to Import → From a connection, select this connection, browse schemas and tables, and click Confirm import.
Connection fields
| Field | Required | Notes |
|---|---|---|
| Connection name | Yes | Display label in Metaustral. |
| Host | Yes | Cluster endpoint. Format: cluster.abc123.us-east-1.redshift.amazonaws.com. |
| Port | Yes | Default: 5439. |
| Database | Yes | The Redshift database to introspect. |
| Username | Yes | Database user with SELECT on information_schema. |
| Password | Yes | Stored encrypted with Fernet. |
| Schema filter | No | Comma-separated. If blank, all schemas are shown. |
Tip: Redshift is PostgreSQL-compatible. You can create a dedicated read-only user with:
CREATE USER metaustral_ro PASSWORD '…'; GRANT SELECT ON ALL TABLES IN SCHEMA information_schema TO metaustral_ro;