Skip to main content

Preflight checks for Amazon Redshift

Before running the Amazon Redshift crawler, you can run preflight checks to perform the necessary technical validations. The following preflight checks will be completed:

Assets​

Database and schema​

✅ Check successful

❌ Check failed for $missingObjectName

Tables count​

✅ Check successful. Table count: <count>

❌ Source returned error/UI default failure message

Tables metadata​

✅ Check successful

❌ Check failed! Please grant select permission on pg_catalog.svv_table_info

External tables metadata​

✅ Check successful

❌ Check failed! Please grant select permission on pg_catalog.svv_external_tables

Miner​

Did you know?

Once you have crawled assets from Amazon Redshift, you can mine query history.

Query history​

DDL​

✅ Check successful

❌ Check failed! Please grant select permission on pg_catalog.stl_ddltext

DML​

✅ Check successful

❌ Check failed! Please grant select permission on pg_catalog.stl_query

Session​

✅ Check successful

❌ Check failed! Please grant select permission on pg_catalog.stl_connection_log

Transaction rollback​

✅ Check successful

❌ Check failed! Please grant select permission on pg_catalog.stl_undone

Insert query​

✅ Check successful

❌ Check failed! Please grant select permission on pg_catalog.stl_insert

S3​

✅ Check successful if the bucket, region, and prefix combination is valid and the S3 credential passed is accessible.

❌Check failed with error code <AWS error code> - <AWS SDK ERR message>

For example: Miner S3 credentials: failed with error code: NoSuchBucket