## Preflight checks for Amazon Redshift

URL: https://docs.atlan.com/apps/connectors/data-warehouses/amazon-redshift/references/preflight-checks-for-amazon-redshift

> Before [running the Amazon Redshift crawler](/apps/connectors/data-warehouses/amazon-redshift/how-tos/crawl-amazon-redshift), you can run [preflight chec.

Before [running the Amazon Redshift crawler](https://docs.atlan.com/llms/connectors/amazon-redshift/crawl-amazon-redshift/llms.txt), you can run [preflight checks](https://docs.atlan.com/llms/catalog/connector-capabilities/what-are-preflight-checks/llms.txt) 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

:::info **Did you know?** 
 Once you have crawled assets from Amazon Redshift, you can [mine query history](https://docs.atlan.com/llms/connectors/amazon-redshift/mine-amazon-redshift/llms.txt).

:::

### 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 - `

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

---