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