What does Atlan crawl from Amazon Redshift?

Have more questions? Submit a request

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

Related articles

Was this article helpful?
1 out of 1 found this helpful