What does Atlan crawl from Snowflake?
During a Snowflake crawl, Atlan extracts metadata for Databases, Schemas, Tables, Views, and Procedures and maps it to Atlan's internal asset model. The tables below list, for each asset type, which Snowflake properties are read and how they appear on the corresponding Atlan asset.
Syncing Snowflake COMMENT fields into the Description field in Atlan is enabled by default. You can disable this behavior using the Sync Comments to Descriptions toggle in the crawler configuration.
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
- Views and Materialised Views - Secure filter
Lineage
Atlan supports lineage for the following asset types:
External Named Stages
- Table
- Pipe → Table
- External Table
- Iceberg Table
Internal Named Stages
- Table
- Pipe → Table (auto ingest not recommended)
- Table -> Stream and Stream -> Table (no column lineage)
- Not supported for External or Iceberg Tables
AI model versions
- Tables, views, dataset versions, feature views, and other models (requires additional permissions)
Databases
Atlan maps databases from Snowflake to its Database asset type.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
DATABASES.DATABASE_NAME | name | asset profile and overview sidebar |
DATABASE.COMMENT | description | asset profile and overview sidebar |
SCHEMATA (count) | schemaCount | asset preview and profile |
DATABASES.DATABASE_OWNER | Created (in Snowflake) | properties sidebar |
DATABASES.CREATED | sourceCreatedAt | properties sidebar |
DATABASES.LAST_ALTERED | sourceUpdatedAt | properties sidebar |
Schemas
Atlan maps schemas from Snowflake to its Schema asset type.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
SCHEMATA.SCHEMA_NAME | name | asset profile and overview sidebar |
SCHEMA.COMMENT | description | asset profile and overview sidebar |
TABLES of type %TABLE% (count) | tableCount | asset preview and profile |
TABLES of type %VIEW% (count) | viewsCount | asset preview and profile |
SCHEMATA.CATALOG_NAME | databaseName | asset preview and profile |
SCHEMATA.SCHEMA_OWNER | Created (in Snowflake) | properties sidebar |
SCHEMATA.CREATED | sourceCreatedAt | properties sidebar |
SCHEMATA.LAST_ALTERED | sourceUpdatedAt | properties sidebar |
Tables
Atlan maps tables from Snowflake to its Table asset type.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
TABLES.TABLE_NAME | name | asset profile and overview sidebar |
TABLES.COMMENT | description | asset profile and overview sidebar |
COLUMNS (count) | columnCount | asset preview and profile, overview sidebar |
TABLES.ROW_COUNT | rowCount | asset preview and profile, overview sidebar |
TABLES.BYTES | sizeBytes | asset filter and overview sidebar |
TABLES.TABLE_OWNER | Created (in Snowflake) | properties sidebar |
TABLES.CREATED | sourceCreatedAt | properties sidebar |
TABLES.LAST_ALTERED | sourceUpdatedAt | properties sidebar |
Iceberg tables
In addition to the table metadata, Atlan supports additional metadata for Iceberg tables crawled from Snowflake. Atlan currently supports fetching metadata for Iceberg tables using both the information schema and account usage extraction methods.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
TABLES.IS_ICEBERG | tableType | asset preview, profile, and filter, and overview sidebar |
ICEBERG_TABLES.CATALOG_NAME | icebergCatalogName | overview sidebar |
ICEBERG_TABLES.ICEBERG_TABLE_TYPE | icebergTableType | overview sidebar |
CATALOG_INTEGRATION.CATALOG_SOURCE | icebergCatalogSource | overview sidebar |
ICEBERG_TABLES.CATALOG_TABLE_NAME | icebergCatalogTableName | overview sidebar |
ICEBERG_TABLES.CATALOG_NAMESPACE | icebergCatalogTableNamespace | overview sidebar |
ICEBERG_TABLES.EXTERNAL_VOLUME_NAME | tableExternalVolumeName | overview sidebar |
ICEBERG_TABLES.BASE_LOCATION | icebergTableBaseLocation | overview sidebar |
TABLES.RETENTION_TIME | tableRetentionTime | overview sidebar |
Views
Atlan maps views from Snowflake to its View asset type.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
TABLES.TABLE_NAME | name | asset profile and overview sidebar |
TABLES.COMMENT | description | asset profile and overview sidebar |
COLUMNS (count) | columnCount | asset preview and profile, overview sidebar |
VIEWS.VIEW_DEFINITION | definition | asset profile and overview sidebar |
TABLES.TABLE_OWNER | Created (in Snowflake) | properties sidebar |
TABLES.CREATED | sourceCreatedAt | properties sidebar |
TABLES.LAST_ALTERED | sourceUpdatedAt | properties sidebar |
Materialized views
Atlan maps materialized views from Snowflake to its MaterialisedView asset type.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
TABLES.TABLE_NAME | name | asset profile and overview sidebar |
TABLES.COMMENT | description | asset profile and overview sidebar |
COLUMNS (count) | columnCount | asset preview and profile, overview sidebar |
TABLES.ROW_COUNT | rowCount | asset preview and profile, overview sidebar |
TABLES.BYTES | sizeBytes | asset filter and overview sidebar |
VIEWS.VIEW_DEFINITION | definition | asset profile and overview sidebar |
TABLES.TABLE_OWNER | Created (in Snowflake) | properties sidebar |
TABLES.CREATED | sourceCreatedAt | properties sidebar |
TABLES.LAST_ALTERED | sourceUpdatedAt | properties sidebar |
External tables
Atlan maps external tables from Snowflake to its Table asset type.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
TABLES.TABLE_NAME | name | asset profile and overview sidebar |
TABLES.COMMENT | description | asset profile and overview sidebar |
COLUMNS (count) | columnCount | asset preview and profile, overview sidebar |
TABLES.ROW_COUNT | rowCount | asset preview and profile, overview sidebar |
TABLES.BYTES | sizeBytes | asset filter and overview sidebar |
EXTERNAL_TABLES.LOCATION | externalLocation | overview sidebar |
STAGES.STAGE_REGION | externalLocationRegion | API only |
EXTERNAL_TABLES.FILE_FORMAT_TYPE | externalLocationFormat | overview sidebar |
TABLES.TABLE_OWNER | Created (in Snowflake) | properties sidebar |
TABLES.CREATED | sourceCreatedAt | properties sidebar |
TABLES.LAST_ALTERED | sourceUpdatedAt | properties sidebar |
Columns
Atlan maps columns from Snowflake to its Column asset type.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
COLUMNS.COLUMN_NAME | name | asset profile and overview sidebar |
COLUMNS.COMMENT | description | asset profile and overview sidebar |
COLUMNS.ORDINAL_POSITION | order | API only |
COLUMNS.DATA_TYPE | dataType | asset filter, preview, and profile, overview sidebar |
PRIMARY KEY | isPrimary | asset preview and filter, overview sidebar |
COLUMNS.IS_NULLABLE | isNullable | overview sidebar |
COLUMNS.CHARACTER_MAXIMUM_LENGTH | maxLength | properties sidebar |
COLUMNS.NUMERIC_PRECISION | precision | properties sidebar |
Stages
Atlan maps stages from Snowflake to its Stage asset type.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
Stages.STAGE_NAME | name | asset profile and overview sidebar |
Stages.COMMENT | description | asset profile and overview sidebar |
Stages.STAGE_SCHEMA | schemaName | asset profile and overview sidebar |
Stages.STAGE_CATALOG | databaseName | asset profile and overview sidebar |
Stages.STAGE_URL | snowflakeStageExternalLocation | asset profile and overview sidebar |
Stages.STAGE_REGION | snowflakeStageExternalLocationRegion | asset profile and overview sidebar |
Stages.STAGE_TYPE | snowflakeStageType | asset profile and overview sidebar |
Stages.STAGE_OWNER | sourceOwners | overview sidebar |
Stages.CREATED | sourceCreatedAt | properties sidebar |
Stages.LAST_ALTERED | sourceUpdatedAt | properties sidebar |
Stages.STORAGE_INTEGRATION | snowflakeStageStorageIntegration | asset profile and overview sidebar |
Streams
Atlan maps streams from Snowflake to its Stream asset type.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
STREAMS.NAME | name | asset profile and overview sidebar |
STREAMS.COMMENT | description | asset profile and overview sidebar |
STREAMS.OWNER | sourceOwners | asset preview and profile, properties sidebar |
STREAMS.DATABASE_NAME | databaseName | asset preview and profile |
STREAMS.SCHEMA_NAME | schemaName | asset preview and profile |
STREAMS.SOURCE_TYPE | snowflakeStreamSourceType | asset filter and overview sidebar |
STREAMS.STALE | snowflakeStreamIsStale | asset filter and overview sidebar |
STREAMS.MODE | snowflakeStreamMode | overview sidebar |
STREAMS.STALE_AFTER | snowflakeStreamStaleAfter | overview sidebar |
Pipes
Atlan maps pipes from Snowflake to its Pipe asset type.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
PIPES.PIPE_NAME | name | asset profile and overview sidebar |
PIPES.COMMENT | description | asset profile and overview sidebar |
PIPES.DEFINITION | definition | asset profile and overview sidebar |
PIPES.PIPE_OWNER | sourceOwners | asset preview and profile, properties sidebar |
PIPES.PIPE_CATALOG | databaseName | asset preview and profile |
PIPES.PIPE_SCHEMA | schemaName | asset preview and profile |
PIPES.IS_AUTOINGEST_ENABLED | snowflakePipeIsAutoIngestEnabled | overview sidebar |
PIPES.NOTIFICATION_CHANNEL_NAME | snowflakePipeNotificationChannelName | overview sidebar |
User-defined functions
Atlan maps user-defined functions (UDFs) from Snowflake to its Function asset type. Atlan supports lineage for UDFs by linking them to the Process assets that use them. Learn more about these relationships in the FAQ.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
NAME | name | asset profile and overview sidebar |
FUNCTION_DEFINITION | functionDefinition | overview sidebar |
COMMENT | description | asset profile and overview sidebar |
FUNCTION_CATALOG | databaseName | asset preview and profile |
FUNCTION_SCHEMA | schemaName | asset preview and profile |
FUNCTION_OWNER | Created (in Snowflake) | properties sidebar |
CREATED | sourceCreatedAt | properties sidebar |
LAST_ALTERED | sourceUpdatedAt | properties sidebar |
FUNCTION_LANGUAGE | functionLanguage | overview sidebar |
DATA_TYPE | functionReturnType | API only |
IS_SECURE | functionIsSecure | asset filter and properties sidebar |
IS_EXTERNAL | functionIsExternal | asset filter and properties sidebar |
IS_MEMOIZABLE | functionIsMemoizable | API only |
ARGUMENT_SIGNATURE | functionArguments | API only |
Dynamic tables
Atlan maps dynamic tables from Snowflake to its DynamicTable asset type.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
TABLES.TABLE_NAME | name | asset profile and overview sidebar |
TABLES.COMMENT | description | asset profile and overview sidebar |
COLUMNS (count) | columnCount | asset preview and profile, overview sidebar |
TABLES.DEFINITION | definition | asset profile and overview sidebar |
TABLES.ROW_COUNT | rowCount | asset preview and profile, overview sidebar |
TABLES.BYTES | sizeBytes | asset filter and overview sidebar |
TABLES.TABLE_OWNER | Created (in Snowflake) | properties sidebar |
TABLES.CREATED | sourceCreatedAt | properties sidebar |
TABLES.LAST_ALTERED | sourceUpdatedAt | properties sidebar |
Stored procedures
Atlan maps Stored procedures from Snowflake to its Procedure asset type. Atlan supports lineage for Stored Procedures by linking them to the Process assets that use them. Learn more about these relationships in the FAQ.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
PROCEDURE_NAME | name | asset preview and profile, overview sidebar and filter |
COMMENT | description | asset preview and profile, overview sidebar |
PROCEDURE_DEFINITION | definition | asset profile and overview sidebar |
CREATED | sourceCreatedAt | asset profile and overview sidebar |
LAST_ALTERED | sourceUpdatedAt | asset profile and overview sidebar |
DATA_TYPE | sqlProcedureReturn | asset profile and overview sidebar |
ARGUMENT_SIGNATURE | sqlArguments | asset profile and overview sidebar |
PROCEDURE_LANGUAGE | sqlLanguage | asset profile and overview sidebar |
RUNTIME_VERSION | sqlRuntimeVersion | asset profile and overview sidebar |
SECRETS | sqlSecrets | asset profile and overview sidebar |
EXTERNAL_ACCESS_INTEGRATIONS | sqlExternalAccessIntegrations | asset profile and overview sidebar |
INSTALLED_PACKAGES | sqlInstalledPackages | asset profile and overview sidebar |
PACKAGES | sqlPackages | asset profile and overview sidebar |
Semantic views
Atlan maps semantic views from Snowflake to its SnowflakeSemanticView asset type.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
SEMANTIC_VIEWS.SEMANTIC_VIEW_NAME | name | asset profile and overview sidebar |
SEMANTIC_VIEWS.COMMENT | description | asset profile and overview sidebar |
SEMANTIC_VIEWS.SEMANTIC_VIEW_OWNER | Created (in Snowflake) | properties sidebar |
SEMANTIC_VIEWS.CREATED | sourceCreatedAt | properties sidebar |
SEMANTIC_VIEWS.LAST_ALTERED | sourceUpdatedAt | properties sidebar |
Semantic logical tables
Atlan maps logical tables within a semantic view to its SnowflakeSemanticLogicalTable asset type.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
SEMANTIC_TABLES.TABLE_NAME | name | asset profile and overview sidebar |
SEMANTIC_TABLES.COMMENT | description | asset profile and overview sidebar |
Semantic dimensions
Atlan maps dimensions within a semantic view to its SnowflakeSemanticDimension asset type.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
SEMANTIC_DIMENSIONS.DIMENSION_NAME | name | asset profile and overview sidebar |
SEMANTIC_DIMENSIONS.COMMENT | description | asset profile and overview sidebar |
Semantic facts
Atlan maps facts within a semantic view to its SnowflakeSemanticFact asset type.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
SEMANTIC_FACTS.FACT_NAME | name | asset profile and overview sidebar |
SEMANTIC_FACTS.COMMENT | description | asset profile and overview sidebar |
Semantic metrics
Atlan maps metrics within a semantic view to its SnowflakeSemanticMetric asset type.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
SEMANTIC_METRICS.METRIC_NAME | name | asset profile and overview sidebar |
SEMANTIC_METRICS.COMMENT | description | asset profile and overview sidebar |
AI models
AI models are crawled only when additional permissions are granted and the Direct + Information Schema extraction method is used. Only models registered in the Snowflake Model Registry are crawled.
Atlan maps AI models from Snowflake to its AIModel asset type.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
MODEL_NAME | name | Asset profile and overview sidebar |
MODEL_CATALOG | databaseName | Asset preview and profile |
MODEL_SCHEMA | schemaName | Asset preview and profile |
AI model versions
Atlan maps AI model versions from Snowflake to its AIModelVersion asset type.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
VERSION_NAME | modelVersionName | Asset profile and overview sidebar |
VERSION_STATUS | modelVersionStatus | Asset profile and overview sidebar |
CREATED | sourceCreatedAt | Properties sidebar |
LAST_ALTERED | sourceUpdatedAt | Properties sidebar |
Listings
Atlan maps Snowflake Marketplace listings to its SnowflakeListing asset type. Listings are account-level objects, so they sit directly under the connection, not inside a database or schema. Atlan reads them from INFORMATION_SCHEMA.LISTINGS, so it crawls listings only under the Information Schema extraction method, not Account Usage.
The standard connector grants don't expose listings and shares. Atlan crawls only the listings the connection role has usage on. See Permissions for Snowflake listings and shares.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
LISTINGS.NAME | name | asset profile and overview sidebar |
LISTINGS.DESCRIPTION | description | asset profile and overview sidebar |
LISTINGS.GLOBAL_NAME | sourceId | API only |
LISTINGS.OWNER | sourceOwners | asset preview and profile, properties sidebar |
LISTINGS.PUBLISHED_ON | sourceCreatedAt | properties sidebar |
LISTINGS.TITLE | snowflakeListingTitle | overview sidebar |
LISTINGS.SUBTITLE | snowflakeListingSubtitle | overview sidebar |
LISTINGS.STATE | snowflakeListingState | overview sidebar |
LISTINGS.DISTRIBUTION | snowflakeListingDistribution | overview sidebar |
LISTINGS.IS_SHARE | snowflakeListingIsShare | overview sidebar |
LISTINGS.IS_APPLICATION | snowflakeListingIsApplication | overview sidebar |
LISTINGS.APPLICATION_PACKAGE | snowflakeListingApplicationPackage | overview sidebar |
LISTINGS.UNIFORM_LISTING_LOCATOR | snowflakeListingUniformListingLocator | overview sidebar |
LISTINGS.CATEGORIES | snowflakeListingCategories | overview sidebar |
LISTINGS.DATA_ATTRIBUTES | snowflakeListingDataAttributes | overview sidebar |
LISTINGS.LISTING_TERMS | snowflakeListingTerms | overview sidebar |
LISTINGS.PROFILE | snowflakeListingProfile | overview sidebar |
LISTINGS.SUPPORT_CONTACT | snowflakeListingSupportContact | overview sidebar |
LISTINGS.RESHARING | snowflakeListingResharing | overview sidebar |
LISTINGS.AUTO_FULFILLMENT | snowflakeListingAutoFulfillment | overview sidebar |
LISTINGS.TARGETS | snowflakeListingTargets | overview sidebar |
Each listing also shows its related shares through the snowflakeShares relationship.
Shares
Atlan maps Snowflake shares to its SnowflakeShare asset type. Like listings, shares are account-level objects read from INFORMATION_SCHEMA.SHARES, so Atlan crawls them only under the Information Schema extraction method, not Account Usage. The view returns both inbound shares (consumed from a provider) and outbound shares (created by your account).
| Source property | Atlan property | Where in Atlan |
|---|---|---|
SHARES.NAME | name | asset profile and overview sidebar |
SHARES.COMMENT | description | asset profile and overview sidebar |
SHARES.OWNER | sourceOwners | asset preview and profile, properties sidebar |
SHARES.DATABASE_NAME | databaseName | asset preview and profile |
SHARES.KIND | snowflakeShareKind | overview sidebar |
SHARES.OWNER_ACCOUNT | snowflakeShareOwnerAccount | overview sidebar |
SHARES.TO | snowflakeShareTargetAccounts | overview sidebar |
SHARES.LISTING_GLOBAL_NAME | snowflakeShareListingGlobalName | overview sidebar |
SHARES.SECURE_OBJECTS_ONLY | snowflakeShareSecureObject | overview sidebar |
When a share is distributed through a listing that was also crawled, the snowflakeListing relationship links the two.