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 |