Snowflake Integration Discovered Resources
Discovered Resources
The Euno-Snowflake integration discovers the following resources:
Snowflake views
Snowflake tables
Snowflake semantic views (including snowflake_metrics & snowflake_dimensions)
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
subtype
always snowflake_account
name
The Snowflake account identifier.
container_type
pure_container
last_integration_run_ended
Timestamp of the last completed integration run (when applicable).
snowflake_warehouses
List of warehouse descriptors. Only present when Observe warehouse information is enabled. See below.
snowflake_warehouses (snowflake_account)
The snowflake_warehouses property is set on the snowflake_account resource only when Observe warehouse information is enabled in the Snowflake integration configuration (the observe_warehouses setting). When enabled, the integration runs SHOW WAREHOUSES and attaches the result to the account resource.
Required configuration: In the Snowflake source settings, turn on Observe warehouse information (or set observe_warehouses to true via API). If this is off, the snowflake_account resource will not have a snowflake_warehouses property.
Contents: A list of warehouse objects. Each object can contain (all fields may be null if not returned by Snowflake):
name
string
Warehouse name.
size
string
Warehouse size (e.g. X-Small, Small, Medium, Large).
state
string
Current state (e.g. STARTED, SUSPENDED).
type
string
Warehouse type (e.g. STANDARD, SNOWPARK-OPTIMIZED).
min_cluster_count, max_cluster_count
number
Min/max clusters for multi-cluster warehouses.
started_clusters, running, queued
number
Cluster and query queue counts.
is_default, is_current
boolean
Whether this warehouse is the default or current for the session.
auto_suspend
number
Auto-suspend delay (seconds).
auto_resume
boolean
Whether auto-resume is enabled.
owner, comment
string
Owner role and optional comment.
created_on, resumed_on, updated_on
datetime
Creation and lifecycle timestamps.
resource_monitor, scaling_policy
string
Resource monitor and scaling policy names.
uuid
string
Snowflake warehouse UUID.
Other fields (e.g. available, provisioning, quiescing, enable_query_acceleration, actives, pendings, failed, suspended) may be present depending on Snowflake’s SHOW WAREHOUSES output.
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, semantic views, snowflake_metrics, snowflake_dimensions
type
always table, with the exception of semantic views, metrics & dimensions
views, tables, base tables, materialized views, temporary tables semantic views, snowflake_metric, snowflake_dimension
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, semantic views, snowflake_metric, snowflake_dimension
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, semantic views
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, semantic views, snowflake_metric, snowflake_dimension
created at
the time this resource was created
views, tables, base tables, materialized views, temporary tables, semantic views, snowflake_metric, snowflake_dimension
updated at
the time this resource's definition was last updated
views, tables, base tables, materialized views, temporary tables, semantic views, snowflake_metric, snowflake_dimension
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
table_schema
Structured schema describing the table or view definition. See Table schema below.
views, tables, base tables, materialized views, temporary tables
Depending on the exact type of the table, Euno determines the subtype of any table.
Table schema (table and view resources)
For table and view resources, the table_schema property holds a structured description of the table’s columns and schema metadata. It has the following shape:
native_schema_name
string or null
Name of the schema in Snowflake, when applicable.
native_schema_type
string
Either "table" or "view" to indicate the kind of object.
columns
list
List of column descriptors (see below).
measures
list
Reserved for measure definitions; typically empty for Snowflake tables/views.
Each entry in columns is an object with:
name
string
Column name.
description
string or null
Column comment from Snowflake, if set.
native_data_type
string
Snowflake data type (e.g. VARCHAR, NUMBER, TIMESTAMP_NTZ).
normalized_data_type
string
Euno-normalized data type.
Other column fields (e.g. native_display_name, native_tags, uri) may be present for compatibility but are not required for understanding Snowflake table and view schemas. 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.
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.
Note: Unlike the distinct-users property available in BI tools with native usage tracking, this distinct-user count does not provide a user breakdown.
tables, base_tables, temporary tables, materialized_views
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
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 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
Customers using a Snowflake tier lower than Enterprise do not have access to usage metrics, including read, write, cost, and storage information.
Last updated