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.SCHEMA_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.IS_NULLABLE |
isNullable |
COLUMNS.CHARACTER_MAXIMUM_LENGTH |
maxLength |
COLUMNS.NUMERIC_PRECISION |
precision |
Streams
Atlan maps streams from Snowflake to its Stream asset type.
| Source property | Atlan property |
|---|---|
STREAMS.NAME |
name |
STREAMS.COMMENT |
description |
STREAMS.OWNER |
sourceOwners |
STREAMS.DATABASE_NAME |
databaseName |
STREAMS.SCHEMA_NAME |
schemaName |
STREAMS.SOURCE_TYPE |
snowflakeStreamSourceType |
STREAMS.STALE |
snowflakeStreamIsStale |
STREAMS.MODE |
snowflakeStreamMode |
STREAMS.STALE_AFTER |
snowflakeStreamStaleAfter |
Pipes
Atlan maps pipes from Snowflake to its Pipe asset type.
| Source property | Atlan property |
|---|---|
PIPES.PIPE_NAME |
name |
PIPES.COMMENT |
description |
PIPES.DEFINITION |
definition |
PIPES.PIPE_OWNER |
sourceOwners |
PIPES.PIPE_CATALOG |
databaseName |
PIPES.PIPE_SCHEMA |
schemaName |
PIPES.IS_AUTOINGEST_ENABLED |
snowflakePipeIsAutoIngestEnabled |
PIPES.NOTIFICATION_CHANNEL_NAME |
snowflakePipeNotificationChannelName |
