What does Atlan crawl from Amazon Redshift?
During an Amazon Redshift crawl, Atlan extracts metadata for Databases, Schemas, Tables, Views, Columns, and Stored procedures. Reference tables map each Redshift property to its Atlan asset.
Atlan extracts metadata for Databases, Schemas, Tables, Views, Columns, and Stored procedures from Amazon Redshift and maps each property to its internal asset model. The tables below list which Amazon Redshift properties are read and how they appear on the corresponding Atlan asset.
Databases
Atlan maps databases from Amazon Redshift to its Database asset type.
| Source property | Atlan property |
|---|---|
| DATABASE_NAME | name |
| SCHEMA_COUNT | schemaCount |
Schemas
Atlan maps schemas from Amazon Redshift to its Schema asset type.
| Source property | Atlan property |
|---|---|
| TABLE_SCHEMA | name |
| TABLE_COUNT | tableCount |
| VIEW_COUNT | viewsCount |
| DATABASE_NAME | databaseName |
| OWNER | sourceCreatedBy |
| SCHEMA_TYPE | subType |
Tables
Atlan maps tables from Amazon Redshift to its Table asset type.
| Source property | Atlan property |
|---|---|
| TABLE_NAME | name |
| REMARKS | description |
| COLUMN_COUNT | columnCount |
| ROW_COUNT | rowCount |
| BYTES | sizeBytes |
| TABLE_TYPE (EXTERNAL TABLE) | subType |
| LOCATION | externalLocation |
| INPUT_FORMAT | externalLocationFormat |
| TABLE_OWNER | sourceCreatedBy |
| CREATED | sourceCreatedAt |
Views
Atlan maps views from Amazon Redshift to its View and MaterialisedView asset types.
| Source property | Atlan property |
|---|---|
| TABLE_NAME | name |
| REMARKS | description |
| COLUMN_COUNT | columnCount |
| VIEW_DEFINITION | definition |
| TABLE_OWNER | sourceCreatedBy |
Columns
Atlan maps columns from Amazon Redshift to its Column asset type.
| Source property | Atlan property |
|---|---|
| COLUMN_NAME | name |
| REMARKS | description |
| ORDINAL_POSITION | order |
| TYPE_NAME | dataType |
| NOTNULL | isNullable |
| CHARACTER_MAXIMUM_LENGTH | maxLength |
| DECIMAL_DIGITS | precision |
| CONSTRAINT_TYPE (PRIMARY KEY) | isPrimary |
| CONSTRAINT_TYPE (FOREIGN KEY) | isForeign |
| SORTKEY | isSort |
| DISKEY | isDist |
Stored procedures
Atlan maps stored procedures from Amazon Redshift to its Procedure asset type. This is available for Redshift Provisioned clusters only. Redshift Serverless doesn't currently expose an equivalent system view and isn't covered by this crawl.
| Source property | Atlan property |
|---|---|
| PROCEDURE_NAME | name |
| ROUTINE_DEFINITION | definition |
| PROCEDURE_OWNER | sourceCreatedBy |
Atlan also updates the Amazon Redshift Discovery search allowlist so that crawled Procedure assets surface in search results.