# Amazon Redshift

Integrate, catalog, and govern Amazon Redshift assets in Atlan.

## Required permissions

- [Preflight checks for Amazon Redshift](https://docs.atlan.com/llms/connectors/amazon-redshift/preflight-checks-for-amazon-redshift/llms.txt): Before running the Amazon Redshift crawler, run preflight checks to verify connectivity, schema access, and miner permissions. Each check maps to a specific error message and fix.

## Setup options

- [Choose how Atlan connects to Amazon Redshift](https://docs.atlan.com/llms/connectors/amazon-redshift/choose-how-atlan-connects-to-amazon-redshift/llms.txt): Compare the three ways Atlan can reach your Amazon Redshift cluster or Serverless workgroup - public IP allowlisting, the AWS private network link, and the self-deployed agent.
- [Firewall & IP allowlisting](https://docs.atlan.com/llms/connectors/amazon-redshift/firewall-and-ip-allowlisting/llms.txt): Allow Atlan's fixed source IPs through your security group so crawlers and miners can connect to publicly accessible Amazon Redshift clusters and workgroups.
- [How private network links work](https://docs.atlan.com/llms/connectors/amazon-redshift/how-the-private-network-link-works/llms.txt): Learn how Redshift-managed VPC endpoints work, who builds which half, and the three traffic paths between Atlan and Amazon Redshift.
- [Set up AWS private network link to Amazon Redshift](https://docs.atlan.com/llms/connectors/amazon-redshift/set-up-a-private-network-link-to-amazon-redshift/llms.txt): Connect Atlan to a private Amazon Redshift cluster over a Redshift-managed VPC endpoint, so traffic never crosses the public internet.
- [Special cases: Serverless & more](https://docs.atlan.com/llms/connectors/amazon-redshift/special-cases-serverless-and-more/llms.txt): Amazon Redshift Serverless, DC2 clusters, multiple clusters, cross-region and cross-cloud tenants, external (Glue/Spectrum) schemas, and sources reachable only from inside your network.
- [Set up access and authentication](https://docs.atlan.com/llms/connectors/amazon-redshift/set-up-access-and-authentication/llms.txt): Create the database user Atlan connects to Amazon Redshift as, grant it read permissions, and choose one of the three authentication methods.
- [Set up Amazon Redshift](https://docs.atlan.com/llms/connectors/amazon-redshift/set-up-amazon-redshift/llms.txt): Grant permissions and configure authentication for Atlan to connect to and crawl metadata from Amazon Redshift.
- [Enable SSO for Amazon Redshift](https://docs.atlan.com/llms/connectors/amazon-redshift/enable-sso-for-amazon-redshift/llms.txt): Configure Okta SSO authentication for Amazon Redshift connections in Atlan, including Okta app setup, AWS identity provider configuration, and Atlan connection settings.
- [Configure ADFS authentication for Amazon Redshift](https://docs.atlan.com/llms/connectors/amazon-redshift/adfs-redshift-access/llms.txt): Configure ADFS authentication for Amazon Redshift connections using ADFS (Active Directory Federation Services) as the identity provider.

## Crawl and mine

- [Crawl Amazon Redshift](https://docs.atlan.com/llms/connectors/amazon-redshift/crawl-amazon-redshift/llms.txt): Once you have configured the Amazon Redshift access permissions, you can establish a connection between Atlan and Amazon Redshift.
- [Mine Amazon Redshift](https://docs.atlan.com/llms/connectors/amazon-redshift/mine-amazon-redshift/llms.txt): Once you have crawled assets from Amazon Redshift, you can mine its query history to construct lineage and retrieve usage and popularity metrics.

## Reference

- [What does Atlan crawl from Amazon Redshift?](https://docs.atlan.com/llms/connectors/amazon-redshift/what-does-atlan-crawl-from-amazon-redshift/llms.txt): During an Amazon Redshift crawl, Atlan extracts metadata for Databases, Schemas, Tables, Views, and Columns. Reference tables map each Redshift property to its Atlan asset.
- [Redshift assets package](https://docs.atlan.com/llms/connectors/amazon-redshift/package-reference/llms.txt): Programmatically crawl and manage Amazon Redshift assets in Atlan using the Python SDK (pyatlan). Reference for the Redshift assets package.

## Troubleshooting

- [Troubleshooting Amazon Redshift connectivity](https://docs.atlan.com/llms/connectors/amazon-redshift/troubleshooting-amazon-redshift-connectivity/llms.txt): Symptom-first troubleshooting for Amazon Redshift connectivity - timeouts, IAM policy scope, role trust, DNS, password failures, Serverless quirks, and sudden breakage.