You can use the Snowflake catalog source to extract metadata from the Snowflake source system.
Snowflake is an analytic data warehouse provided as Software-as-a-Service (SaaS). The Snowflake data warehouse uses an SQL database engine with a unique architecture designed for cloud services.
Extracted metadata
You can use the Snowflake catalog source to extract metadata from a Snowflake source system.
The metadata extraction service extracts the following objects from a Snowflake source system:
•Database
•Schema
•Table
•Tag
•View
•Materialized View
Note:
Objects of the Materialized View type appear as View in
Data Governance and Catalog
.
•Function
Note:
Objects of the Function type appear as Stored Procedure in
Data Governance and Catalog
.
•Stored Procedure
Note:
To extract Data Definition Language (DDL) statements from a stored procedure, you need owner privileges on the stored procedure. Alternatively, you can re-create the stored procedure with the
EXECUTE AS CALLER
clause.
•Pipe
•Stage
•Column
•External Table
- Iceberg Table
Secure Data Sharing in Snowflake allows you to share selected database assets with other Snowflake accounts without copying or transferring any actual data. To share data, providers create a share of their database, select specific objects to include, and then add consumer accounts to this share.
You can extract metadata from the following database assets shared through Snowflake Secure Data Sharing:
•Database
•Table
•External table
•Secure view
•Secure materialized view
To view the complete data lineage and all the metadata extracted for the consumer account, including shared assets, perform a connection assignment between catalog sources created for the provider and consumer Snowflake accounts.
Data profiling for Snowflake objects
Configure data profiling to run profiles on the metadata extracted from a Snowflake source system.
You can run data profiles on the following Snowflake objects:
•Hybrid Table
•Table
•View
The data profiling task runs profiles on the following data types for Snowflake objects:
•NUMBER
•FLOAT
•DOUBLE
•VARCHAR
•BOOLEAN
•DATE
•TIME
•TIMESTAMP_LTZ
•TIMESTAMP_NTZ
•TIMESTAMP_TZ
•OBJECT
•ARRAY
•VARIANT
Compatible connectors
Before you configure a Snowflake catalog source, you must connect to the Snowflake source system.
Use the Snowflake Data Cloud connector to connect to the Snowflake source system. For information about configuring a connection, see Connections in the Administrator help.