What does Atlan crawl from Snowflake?

Have more questions? Submit a request

Atlan crawls and maps the following assets and properties from Snowflake.

Databases

Atlan maps databases from Snowflake to its Database asset type.

Source property Atlan property
DATABASES.DATABASE_NAME name
SCHEMATA (count) schemaCount
DATABASES.DATABASE_OWNER sourceCreatedBy
DATABASES.CREATED sourceCreatedAt
DATABASES.LAST_ALTERED sourceUpdatedAt

Schemas

Atlan maps schemas from Snowflake to its Schema asset type.

Source property Atlan property
SCHEMATA.SCHEMA_NAME name
TABLES of type %TABLE% (count) tableCount
TABLES of type %VIEW% (count) viewsCount
SCHEMATA.CATALOG_NAME databaseName
SCHEMATA.DATABASE_OWNER sourceCreatedBy
SCHEMATA.CREATED sourceCreatedAt
SCHEMATA.LAST_ALTERED sourceUpdatedAt

Tables

Atlan maps tables from Snowflake to its Table asset type.

Source property Atlan property
TABLES.TABLE_NAME name
TABLES.COMMENT description
COLUMNS (count) columnCount
TABLES.ROW_COUNT rowCount
TABLES.BYTES sizeBytes
TABLES.TABLE_OWNER sourceCreatedBy
TABLES.CREATED sourceCreatedAt
TABLES.LAST_ALTERED sourceUpdatedAt

Views

Atlan maps views from Snowflake to its View asset type.

Source property Atlan property
TABLES.TABLE_NAME name
TABLES.COMMENT description
COLUMNS (count) columnCount
VIEWS.VIEW_DEFINITION definition
TABLES.TABLE_OWNER sourceCreatedBy
TABLES.CREATED sourceCreatedAt
TABLES.LAST_ALTERED sourceUpdatedAt

Materialized views

Atlan maps materialized views from Snowflake to its MaterialisedView asset type.

Source property Atlan property
TABLES.TABLE_NAME name
TABLES.COMMENT description
COLUMNS (count) columnCount
TABLES.ROW_COUNT rowCount
TABLES.BYTES sizeBytes
VIEWS.VIEW_DEFINITION definition
TABLES.TABLE_OWNER sourceCreatedBy
TABLES.CREATED sourceCreatedAt
TABLES.LAST_ALTERED sourceUpdatedAt

External tables

Atlan maps external tables from Snowflake to its Table asset type.

Source property Atlan property
TABLES.TABLE_NAME name
TABLES.COMMENT description
COLUMNS (count) columnCount
TABLES.ROW_COUNT rowCount
TABLES.BYTES sizeBytes
EXTERNAL_TABLES.LOCATION externalLocation
STAGES.STAGE_REGION externalLocationRegion
EXTERNAL_TABLES.FILE_FORMAT_TYPE externalLocationFormat
TABLES.TABLE_OWNER sourceCreatedBy
TABLES.CREATED sourceCreatedAt
TABLES.LAST_ALTERED sourceUpdatedAt

Stages

Atlan maps stages from Snowflake to its Table asset type.

Source property Atlan property
TABLES.TABLE_NAME name
TABLES.COMMENT description
COLUMNS (count) columnCount
TABLES.ROW_COUNT rowCount
TABLES.BYTES sizeBytes
EXTERNAL_TABLES.LOCATION externalLocation
STAGES.STAGE_REGION externalLocationRegion
EXTERNAL_TABLES.FILE_FORMAT_TYPE externalLocationFormat
TABLES.TABLE_OWNER sourceCreatedBy
TABLES.CREATED sourceCreatedAt
TABLES.LAST_ALTERED sourceUpdatedAt

Columns

Atlan maps columns from Snowflake to its Column asset type.

Source property Atlan property
COLUMNS.COLUMN_NAME name
COLUMNS.COMMENT description
COLUMNS.ORDINAL_POSITION order
COLUMNS.DATA_TYPE dataType
COLUMNS.NULLABLE isNullable
COLUMNS.CHARACTER_MAXIMUM_LENGTH maxLength
COLUMNS.DECIMAL_DIGITS precision

Related articles

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