Troubleshooting Amazon Redshift connectivity

What are the known limitations of the Amazon Redshift connector?

If you run the miner for an Amazon Redshift connection 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 for external schemas and tables in Amazon Redshift.

If you would like to query an external schema in Amazon Redshift from Atlan, you will need to write the query in Insights with the fully qualified name and keep the editor context empty — for example, select * db.schema.table and as shown here:

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.

Related articles

Was this article helpful?
0 out of 0 found this helpful