Atlan crawls and maps the following assets and properties from Snowflake.
Once you've crawled Snowflake, you can use connector-specific filters for quick asset discovery. The following filters are currently supported for Snowflake assets:
- Streams — Source type and Stale filters
- Functions — Language, Function type, Is secure, and Is external filters
- Snowflake tags and tag values
Databases
Atlan maps databases from Snowflake to its Database asset type.
| Source property | Atlan property |
|---|---|
DATABASES.DATABASE_NAME |
name |
DATABASE.COMMENT |
description |
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 |
SCHEMA.COMMENT |
description |
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 |
PRIMARY KEY |
isPrimary |
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 |
User-defined functions
Atlan maps user-defined functions (UDFs) from Snowflake to its Function asset type.
| Source property | Atlan property |
|---|---|
NAME |
name |
FUNCTION_DEFINITION |
functionDefinition |
COMMENT |
description |
FUNCTION_CATALOG |
databaseName |
FUNCTION_SCHEMA |
schemaName |
FUNCTION_OWNER |
sourceCreatedBy |
CREATED |
sourceCreatedAt |
LAST_ALTERED |
sourceUpdatedAt |
FUNCTION_LANGUAGE |
functionLanguage |
DATA_TYPE |
functionReturnType |
IS_SECURE |
functionIsSecure |
IS_EXTERNAL |
functionIsExternal |
IS_MEMOIZABLE |
functionIsMemoizable |
Dynamic tables
🚨 Careful! Atlan currently does not support lineage for dynamic tables from Snowflake.
Atlan maps dynamic tables from Snowflake to its DynamicTable 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 |
