Preflight checks for Amazon Redshift

Have more questions? Submit a request

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

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

Related articles

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