## What does Atlan crawl from Snowflake?

URL: https://docs.atlan.com/apps/connectors/data-warehouses/snowflake/references/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.

:::note

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](https://docs.atlan.com/llms/connectors/snowflake/crawl-snowflake/llms.txt) in the crawler configuration.

:::

Once you've [crawled Snowflake](https://docs.atlan.com/llms/connectors/snowflake/crawl-snowflake/llms.txt), you can [use connector-specific filters](https://docs.atlan.com/llms/catalog/discovery/use-the-filters-menu/llms.txt) for quick asset discovery. The following filters are currently supported for Snowflake assets:

- [Streams](#streams) - Source type and Stale filters
- [Functions](#user-defined-functions) - Language, Function type, Is secure, and Is external filters
- [Snowflake tags and tag values](https://docs.atlan.com/llms/governance/tags/attach-a-tag/llms.txt)
- [Views](#views) and [Materialised Views](#materialized-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

## 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](https://docs.atlan.com/llms/connectors/snowflake/stored-procedures-udfs-and-process-assets/llms.txt).

| 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](https://docs.atlan.com/llms/connectors/snowflake/stored-procedures-udfs-and-process-assets/llms.txt).

| 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.

:::info Additional permissions required
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](https://docs.atlan.com/llms/connectors/snowflake/permissions-for-snowflake-listings-and-shares/llms.txt).
:::

| 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](https://docs.atlan.com/llms/connectors/snowflake/where-snowflake-listings-and-shares-appear/llms.txt).

## 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](https://docs.atlan.com/llms/connectors/snowflake/where-snowflake-listings-and-shares-appear/llms.txt).

---