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.
type
always snowflake_account
Snowflake Basic Properties
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.
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.
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.
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