Snowflake Metadata Extracted

List of all the metadata that Secoda pulls from/pushes to Snowflake

Metadata pulled

Secoda pulls the following metadata from Snowflake:

• Tables

  • Name

  • Description

  • Last Updated Timestamp

  • External Usage (Popularity)

  • Schema

  • Database

  • Frequent Users

• Views (Views are referred to as Tables in Secoda)

  • Name

  • Description

  • Last Updated Timestamp

  • External Usage

  • Schema

  • Database

  • Frequent Users

• Columns

  • Name

  • Description

  • Type

  • Foreign Key

  • Primary Key

• Column Profile

  • Min

  • Max

  • Median

  • STD Deviation

  • Value distribution

  • Statistic Value Count

  • Percent Filled

  • Unique

• Creation Query

• Common Queries

• Lineage

  • Snowflake Column <-> Snowflake Column

  • Snowflake Table <-> Snowflake Table

  • Snowflake Table <-> Dashboards from other sources

  • Snowflake Table <-> Jobs from other sources

  • Snowflake Column <-> Snowflake View

  • Snowflake Table <-> Snowflake View

• Preview of first 50 rows (Optional)

Metadata pushed

If enabled, Secoda pushes the following metadata to Snowflake:

• Tables

  • Description

• Columns

  • Description

It only looks at the tables that have been published and all of their columns. If a table isn't published in Secoda and you run a sync, it will not push back to the source.

Please ensure ensure the SECODA role has INSERT table privileges, as well as MODIFY schema and database. You can check what privileges the role has by running SHOW GRANTS TO ROLE SECODA. The SECODA user must also be an owner of the tables.