What does Atlan crawl from Amazon Redshift?
Atlan crawls and maps the following assets and properties from Amazon Redshift.
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.
| Source property | Atlan property |
|---|---|
| PROCEDURE_NAME | name |
| REMARKS | description |
| PROCEDURE_TYPE | subType |
| ROUTINE_DEFINITION | definition |
| PROC_OWNER | sourceCreatedBy |