What does Atlan crawl from Amazon Redshift?
Atlan extracts metadata for Databases, Schemas, Tables, Views, and Columns 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 |