What does Atlan crawl from Snowflake?
During a Snowflake crawl, Atlan extracts metadata for Databases, Schemas, Tables, Views, and Procedures. Reference tables map each Snowflake property to its Atlan asset.
Atlan crawls Snowflake metadata for databases, schemas, tables, views, and procedures, mapping each property to its Atlan asset and building column-level lineage.
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
Horizon
Horizon is Snowflake's native governance layer. Atlan reads object tags from Horizon and synchronizes them bidirectionally between Snowflake and Atlan.
Atlan doesn't read masking policies, row access policies, aggregation policies, or projection policies from Horizon. Those governance controls are enforced entirely inside Snowflake and aren't represented as assets or attributes in Atlan.
Object tags
Object tag synchronization relies on ACCOUNT_USAGE.TAGS and ACCOUNT_USAGE.TAG_REFERENCES, which are available in Snowflake Enterprise Edition and later.
Atlan imports Snowflake object tags from ACCOUNT_USAGE.TAGS and uses ACCOUNT_USAGE.TAG_REFERENCES to determine which tags are assigned to each Snowflake object. Atlan then matches the Snowflake tag names with Atlan tags, ignoring case.
- If a matching Atlan tag exists, Atlan applies the tag and its value to the corresponding Snowflake assets.
- If no matching Atlan tag exists, Atlan ignores the Snowflake tag unless the connection is configured to create new Atlan tags during import.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
TAGS.TAG_NAME | Matched Atlan tag | Asset profile and overview sidebar |
TAGS.ALLOWED_VALUES | Tag allowed values | Tag manager |
TAG_REFERENCES.TAG_VALUE | Atlan tag value on the asset | Asset profile and overview sidebar |
TAG_REFERENCES.OBJECT_DATABASE, OBJECT_SCHEMA, OBJECT_NAME | Tag attachment on the corresponding asset | Asset profile and overview sidebar |
Synchronization is bidirectional: attaching, detaching, or updating a tag value in Atlan pushes the change back to Snowflake. For setup steps and prerequisites, see Manage Snowflake tags.
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 |
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. For what a listing's asset profile displays and how to open the share it distributes, see Where Snowflake listings and shares appear in Atlan.
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.
Shares also add context to the SQL assets they contain: an asset that belongs to a share gains a Shares section, and a database imported from an inbound share is marked as an imported database. See Where Snowflake listings and shares appear in Atlan.