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 |
