## Troubleshooting Amazon Redshift connectivity

URL: https://docs.atlan.com/apps/connectors/data-warehouses/amazon-redshift/troubleshooting/troubleshooting-amazon-redshift-connectivity

> Learn about troubleshooting amazon redshift connectivity.

#### What are the known limitations of the Amazon Redshift connector?

If you run the [miner](https://docs.atlan.com/llms/connectors/amazon-redshift/mine-amazon-redshift/llms.txt) for an [Amazon Redshift connection](https://docs.atlan.com/llms/connectors/amazon-redshift/crawl-amazon-redshift/llms.txt) with _Serverless_ deployment type, lineage will be missing for queries with comments included. This is a limitation of AWS - queries with comments do not include line breaks when fetched from query history.

#### Why do I get an error when querying an external schema in Amazon Redshift?

Atlan currently does not support [search paths](https://docs.aws.amazon.com/redshift/latest/dg/r_search_path.html) for external schemas and tables in Amazon Redshift.

To query an external schema in Amazon Redshift from Atlan, you need to write the query in Data Exploration with the fully qualified name and keep the editor context empty - for example, `select * db.schema.table` and as shown here:

![editor_context.png](https://docs.atlan.com/img/apps/connectors/data-warehouse/amazon-redshift/references/editor-context.png)

#### Does Atlan support connecting to Amazon Redshift via SSL?

Yes, Atlan supports connecting to Amazon Redshift over the Secure Sockets Layer (SSL) protocol. If your Amazon Redshift cluster is configured to require an SSL connection, with the `require_SSL` parameter set to `true`, Atlan will be able to connect to your cluster.

---