Snowflake Integration Discovered Resources

Discovered Resources

The Euno-Snowflake integration discovers the following resources:

  • Snowflake views

  • Snowflake tables

  • Snowflake account

Snowflake Tables and Views

Property
Value
Applicable to

name

The name of the Snowflake resource. This does not include the database or schema. So, for example, if the full name is some_database.some_schema.some_resource, then Euno will set the name to some_resource

views, tables

type

always table

views, tables

database technology

always snowflake

views, tables

materialized

false for views, true for tables

views, tables

schema

the name of the snowflake schema this resource is in. For example, for some_database.some_schema.some_resource, this will be set to some_schema.

views, tables

database

the name of the snowflake database this resource is in. For example, for some_database.some_schema.some_resource, this will be set to some_database.

views, tables

created at

the time this resource was created

views, tables

updated at

the time this resource's definition was last updated

views, tables

description

If the resource has a COMMENT, then it will be used as the description

views, tables

owner

The Snowflake users set as the owner of the resource

views, tables

row_count

The number of rows in the table.

tables

volume

The size of the table in bytes.

tables

total_queries_14d

The total number of queries that referenced this resource over the last 14 days. This information is taken from the Snowflake query history.

views, tables

total_queries_30d

The total number of queries that referenced this resource over the last 30 days. This information is taken from the Snowflake query history.

views, tables

total_queries_60d

The total number of queries that referenced this resource over the last 60 days. This information is taken from the Snowflake query history.

views, tables

distinct_users_14d

The number of distinct users who queried this resource over the last 14 days. This information is taken from the Snowflake query history.

views, tables

distinct_users_30d

The number of distinct users who queried this resource over the last 30 days. This information is taken from the Snowflake query history.

views, tables

distinct_users_60d

The number of distinct users who queried this resource over the last 60 days. This information is taken from the Snowflake query history.

views, tables

Snowflake account

The Snowflake integration also discovers the Snowflake account itself as a resource. This resource is used internally by Euno and is not directly exposed to users in the data model.

Relationships

The Snowflake integration discovers the following relationships between resources:

Parent-Child Relationships

  • Snowflake Account → Tables/Views: Tables and views are considered children of the Snowflake account resource.

Upstream-Downstream Relationships

  • Table Dependencies: When a view references other tables or views in its definition, Euno captures these dependencies.

    • The referenced tables/views are considered "upstream" of the view that references them.

    • The view is considered "downstream" of the tables/views it references.

These relationships allow you to understand the lineage of your data and how different Snowflake resources are connected to each other. You can use these relationships to:

  • Trace data flows through your Snowflake environment

  • Understand the impact of changes to upstream resources

  • Identify which resources depend on a particular table or view

Last updated