Snowflake Integration Discovered Resources
Discovered Resources
The Euno-Snowflake integration discovers the following resources:
Snowflake views
Snowflake tables
Snowflake account
Snowflake table columns
Hex Projects (when "Extract Hex Resources" is enabled)
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
Depending on the exact type of the table, Euno determines the subtype of any table. Euno scans the query history for all references to tables. If Euno encounters a reference a reference to a table that does not exist in the information_schema.tables table, then Euno observes it as a table resource with temporary table as the subtype.
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
Hex Projects
Properties
name
The name of the Hex project
type
always hex_project
subtype
always hex_project
native_id
The unique project ID from Hex
Lineage Information
The Snowflake integration tracks which Snowflake tables and columns are accessed by each Hex project through query history analysis. This provides:
Data Dependencies: Understanding how Hex projects depend on specific Snowflake resources
Access Patterns: Which tables and databases are most frequently accessed by Hex projects
Impact Analysis: Understanding which Hex projects might be affected by changes to Snowflake resources
Last updated