Snowflake Integration Discovered Resources

Discovered Resources

The Euno-Snowflake integration discovers the following resources:

  • Snowflake views

  • Snowflake tables

  • Snowflake account

  • Snowflake table columns

Snowflake account

A single resource of type "snowflake_account" is observed.

Property
Value

type

always snowflake_account

Snowflake Basic Properties

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, base tables, materialized views, temporary tables

type

always table

views, tables, base tables, materialized views, temporary tables

subtype

The type of table; temporary table, table, base_table, materialized_view, view

views, tables, base tables, materialized views, temporary tables

database technology

always snowflake

views, tables, base tables, materialized views, temporary tables

materialized

false for views, true for tables

views, tables, base tables, materialized views, temporary 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, base tables, materialized views, temporary 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, base tables, materialized views, temporary tables

created at

the time this resource was created

views, tables, base tables, materialized views, temporary tables

updated at

the time this resource's definition was last updated

views, tables, base tables, materialized views, temporary tables

description

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

views, tables, base tables, materialized views, temporary tables

owner

The Snowflake users set as the owner of the resource

views, tables, base tables, materialized views, temporary tables

defined_by

The technology used to define the Snowflake resource (e.g. dbt)

views, tables, base tables, materialized views, temporary tables

Snowflake Usage & Optimization Properties

Usage and cost optimization properties are derived from the Snowflake query logs. For Euno to ingest and surface this data, Snowflake must have query logging enabled.

Write Properties

Write-related properties capture activity from SQL statements such as INSERT, UPDATE, DELETE, and MERGE. These metrics apply to both tables and materialized views.

Property
Value
Applicable to

total_write_queries_14d total_write_queries_30d total_write_queries_60d

Total number of write operations (INSERT, UPDATE, DELETE, MERGE) involving the table in the last 14/30/60 days.

tables, base_tables, temporary tables, materialized_view

total_write_credits_14d total_write_credits_30d total_write_credits_60d

Total compute credits consumed by write operations (INSERT, UPDATE, DELETE, MERGE) involving the table in the last 14/30/60 days.

tables, base_tables, temporary tables, materialized_view

average_write_credits_14d average_write_credits_30d average_write_credits_60d

Average compute credits consumed by write operations (INSERT, UPDATE, DELETE, MERGE) involving the table in the last 14/30/60 days.

tables, base_tables, temporary tables, materialized_view

total_write_cost_14d total_write_cost_30d total_write_cost_60d

Total compute cost of write operations (INSERT, UPDATE, DELETE, MERGE) involving the table over the last 14/30/60 days, calculated by converting compute credits using your configured credit-to-dollar rate.

tables, base_tables, temporary tables, materialized_view

average_write_cost_14d average_write_cost_30d average_write_cost_60d

Average compute cost per write operation (INSERT, UPDATE, DELETE, MERGE) involving the table over the last 14/30/60 days, calculated by converting compute credits using your configured credit-to-dollar rate.

tables, base_tables, temporary tables, materialized_view

total_write_runtime_14d total_write_runtime_30d total_write_runtime_60d

Total runtime of write-related operations (INSERT, UPDATE, DELETE, MERGE) involving the table over the last 14/30/60 days.

tables, base_tables, temporary tables, materialized_views

Read Properties

Read properties include activity from SQL statements such as SELECT. These properties apply to all Snowflake table subtypes.

Property
Value
Applicable to

total_read_queries_14d total_read_queries_30d total_read_queries_60d

Total number of queries referencing (SELECT queries) the resource over the last 14/30/60 days.

tables, base_tables, temporary tables, materialized_views

total_read_credits_14d total_read_credits_30d total_read_credits_60d

Total compute credits consumed by read operations (SELECT queries) referencing the resource over the last 14/30/60 days.

tables, base_tables, temporary tables, materialized_views

average_read_credits_14d average_read_credits_30d average_read_credits_60d

Average compute credits per read operation (SELECT query) referencing the resource over the last 14/30/60 days.

tables, base_tables, temporary tables, materialized_views

total_read_cost_14d total_read_cost_30d total_read_cost_60d

Total compute cost of read operations (SELECT queries) referencing the resource over the last 14/30/60 days, calculated by converting compute credits using your configured credit-to-dollar rate.

tables, base_tables, temporary tables, materialized_views

average_read_cost_14d average_read_cost_30d average_read_cost_60d

Average compute cost per read operation (SELECT query) referencing the resource over the last 14/30/60 days, calculated by converting compute credits using your configured credit-to-dollar rate.

tables, base_tables, temporary tables, materialized_views

distinct_users_14d distinct_users_30d distinct_users_60d

Number of distinct users who queried (SELECT queries) the resource over the last 14/30/60 days.

tables, base_tables, temporary tables, materialized_views

Storage Properties

Storage properties reflect the current size of the table as stored in Snowflake. They are used to estimate storage costs based on configured pricing settings and are applicable to all table types.

Property
Value
Applicable to

volume

The number of rows in the table.

tables, base_tables, temporary tables, materialized_views

row_count

Current table volume as stored in the database (in bytes)

tables, base_tables, temporary tables, materialized_views

projected_storage_cost

Calculated using table volume and the $/TB/month rate from your Snowflake source settings.

tables, base_tables, temporary tables, materialized_views

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.

Defines-by Relationships

  • Snowflake tables can be defined by a different resource (e.g., dbt_model) that determine their structure and logic.

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