Snowflake Integration Discovered Resources
Ingested Resources & Properties
Snowflake account (snowflake_account)
snowflake_account)The Snowflake account is the top-level Snowflake resource observed by the integration.
name
Snowflake account identifier.
type
Always snowflake_account.
subtype
Always snowflake_account.
container_type
Marks the account as a pure container.
snowflake_warehouses
Warehouse descriptors from SHOW WAREHOUSES. Only present when Observe warehouse information is enabled.
snowflake_tableau_usage_raw
Encoded raw Tableau usage records discovered from Snowflake query history.
last_integration_run_ended
Timestamp of the last completed integration run.
When snowflake_warehouses is present, each warehouse object may include fields such as name, size, state, type, min_cluster_count, max_cluster_count, started_clusters, running, queued, is_default, is_current, auto_suspend, auto_resume, owner, comment, created_on, resumed_on, updated_on, resource_monitor, scaling_policy, and uuid. Other fields may be present depending on Snowflake's SHOW WAREHOUSES output.
Database (database)
database)Snowflake databases are observed as container resources.
name
Database name.
type
Always database.
subtype
Always database.
container_type
Marks the database as a pure container.
parent_container
The parent snowflake_account.
Database schema (database_schema)
database_schema)Snowflake schemas are observed as container resources under databases.
name
Schema name.
type
Always database_schema.
subtype
Always database_schema.
container_type
Marks the schema as a pure container.
parent_container
The parent database.
Table and view (table)
table)Snowflake tables, views, materialized views, base tables, and temporary tables are represented as table resources. Euno uses the subtype property to distinguish the Snowflake object kind.
name
Object name, excluding database and schema.
type
Always table.
subtype
Snowflake object kind, such as table, base_table, view, materialized_view, or temporary table.
description
Snowflake comment, when present.
platform_uri_prefix
Snowflake URI prefix used to generate resource URIs.
database_technology
Always snowflake.
database_database
Snowflake database name.
database_schema
Snowflake schema name.
parent_container
Parent database_schema.
native_owners
Snowflake owner role or user references.
native_last_data_update
Last observed data update time from write activity.
created_at
Object creation timestamp.
updated_at
Last altered timestamp.
row_count
Current row count reported by Snowflake.
volume
Current storage size in bytes.
projected_storage_cost
Estimated monthly storage cost based on configured storage pricing.
table_properties
Structured table or view details, including materialization state and view SQL when available.
table_schema
Structured schema with column names, comments, and data types.
is_shared
Indicates that the resource is part of a configured outbound share.
snowflake_query_history_upstream
Upstream table URIs inferred from Snowflake access history.
upstream_temp_tables
Details about temporary tables that participate in query-history lineage.
Usage and cost optimization properties can also be set on table resources:
total_read_queries_14d, total_read_queries_30d, total_read_queries_60d
Number of read queries over the last 14, 30, or 60 days.
total_read_credits_14d, total_read_credits_30d, total_read_credits_60d
Total read compute credits over the last 14, 30, or 60 days.
average_read_credits_14d, average_read_credits_30d, average_read_credits_60d
Average read compute credits per query over the last 14, 30, or 60 days.
total_read_cost_14d, total_read_cost_30d, total_read_cost_60d
Total read cost over the last 14, 30, or 60 days.
average_read_cost_14d, average_read_cost_30d, average_read_cost_60d
Average read cost per query over the last 14, 30, or 60 days.
total_write_queries_14d, total_write_queries_30d, total_write_queries_60d
Number of write operations over the last 14, 30, or 60 days.
total_write_credits_14d, total_write_credits_30d, total_write_credits_60d
Total write compute credits over the last 14, 30, or 60 days.
average_write_credits_14d, average_write_credits_30d, average_write_credits_60d
Average write compute credits per operation over the last 14, 30, or 60 days.
total_write_cost_14d, total_write_cost_30d, total_write_cost_60d
Total write cost over the last 14, 30, or 60 days.
average_write_cost_14d, average_write_cost_30d, average_write_cost_60d
Average write cost per operation over the last 14, 30, or 60 days.
total_write_runtime_14d, total_write_runtime_30d, total_write_runtime_60d
Total runtime of write operations over the last 14, 30, or 60 days.
total_dml_queries_14d, total_dml_queries_30d, total_dml_queries_60d
Deprecated DML query counts retained for compatibility.
total_dml_runtime_14d, total_dml_runtime_30d, total_dml_runtime_60d
Deprecated DML runtime metrics retained for compatibility.
total_dml_credits_14d, total_dml_credits_30d, total_dml_credits_60d
Deprecated DML credit metrics retained for compatibility.
total_dml_cost_14d, total_dml_cost_30d, total_dml_cost_60d
Deprecated DML cost metrics retained for compatibility.
total_queries_14d, total_queries_30d, total_queries_60d
Total query count over the last 14, 30, or 60 days.
distinct_users_14d, distinct_users_30d, distinct_users_60d
Number of distinct users who queried the table over the last 14, 30, or 60 days.
Snowflake usage metrics appear only when Euno can observe usable Snowflake query or access history. If that history is unavailable or yields no usable events, these fields may remain empty instead of showing 0.
Column (column)
column)Snowflake table and view columns are represented as column resources.
name
Column name.
type
Always column.
subtype
Always column.
description
Snowflake column comment, when present.
parent_container
Parent table.
parent_name
Parent table or view name.
native_data_type
Snowflake data type.
normalized_data_type
Euno-normalized data type.
database_technology
Always snowflake.
database_database
Snowflake database name.
database_schema
Snowflake schema name.
snowflake_query_history_upstream_columns
Upstream column URIs inferred from Snowflake access history.
total_read_queries_14d, total_read_queries_30d, total_read_queries_60d
Column read query counts over the last 14, 30, or 60 days. Only present when column-level usage is enabled.
distinct_users_14d, distinct_users_30d, distinct_users_60d
Distinct users who read the column over the last 14, 30, or 60 days. Only present when column-level usage is enabled.
Snowflake semantic view (snowflake_semantic_view)
snowflake_semantic_view)Snowflake semantic views are observed when semantic view discovery is enabled.
name
Semantic view name.
type
Always snowflake_semantic_view.
description
Semantic view description from Snowflake, when present.
parent_container
Parent database_schema.
native_raw_object
Parsed semantic view YAML definition.
raw_code
Raw semantic view YAML definition.
database_database
Snowflake database name.
database_schema
Snowflake schema name.
database_technology
Always snowflake.
platform_uri_prefix
Snowflake URI prefix used to generate resource URIs.
created_at
Semantic view creation timestamp.
updated_at
Last altered timestamp.
native_owners
Snowflake owner role reference.
table_dependencies
Upstream Snowflake table URIs used by the semantic view.
native_id
Native semantic view identifier.
external_links
Link to open the semantic view in Snowflake, when host and object context are available.
total_read_queries_14d, total_read_queries_30d, total_read_queries_60d
Semantic view read query counts over the last 14, 30, or 60 days.
distinct_users_14d, distinct_users_30d, distinct_users_60d
Distinct users who queried the semantic view over the last 14, 30, or 60 days.
total_read_credits_14d, total_read_credits_30d, total_read_credits_60d
Semantic view read credits over the last 14, 30, or 60 days.
Snowflake dimension (snowflake_dimension)
snowflake_dimension)Snowflake dimensions are child resources of a Snowflake semantic view.
name
Dimension name.
type
Always snowflake_dimension.
parent_container
Parent snowflake_semantic_view.
upstream_fields
Upstream Snowflake column URIs used by the dimension expression.
native_data_type
Snowflake data type.
normalized_data_type
Euno-normalized data type.
raw_code
Dimension expression.
created_at
Dimension creation timestamp, when present in Snowflake metadata.
updated_at
Dimension update timestamp, when present in Snowflake metadata.
description
Dimension description, when present.
synonyms
Dimension synonyms from Snowflake metadata.
native_raw_object
Raw dimension object from the semantic view definition.
native_id
Native dimension identifier.
Snowflake metric (snowflake_metric)
snowflake_metric)Snowflake metrics are child resources of a Snowflake semantic view.
name
Metric name.
type
Always snowflake_metric.
subtype
derived for metrics, or base when emitted from facts.
parent_container
Parent snowflake_semantic_view.
upstream_fields
Upstream Snowflake column URIs used by the metric expression.
native_data_type
Snowflake data type.
normalized_data_type
Euno-normalized data type.
raw_code
Metric expression.
aggregation
Metric aggregation, when provided by Snowflake.
created_at
Metric creation timestamp, when present in Snowflake metadata.
updated_at
Metric update timestamp, when present in Snowflake metadata.
description
Metric description, when present.
synonyms
Metric synonyms from Snowflake metadata.
native_raw_object
Raw metric object from the semantic view definition.
native_id
Native metric identifier.
Snowflake inbound share (snowflake_inbound_share)
snowflake_inbound_share)Inbound shares are observed when Observe inbound Snowflake shares is enabled.
name
Share name.
type
Always snowflake_inbound_share.
subtype
Always inbound_share.
description
Share comment from Snowflake, when present.
native_id
Snowflake account and share identifier.
parent_container
Parent snowflake_account.
database_technology
Always snowflake.
native_raw_object
Raw share metadata from Snowflake.
native_owners
Share owner, when present.
defines
Database URI defined by the share, when Euno can match it to an observed database.
table_dependencies
Matching outbound share URI, when an inbound and outbound share with the same name are observed.
Snowflake outbound share (snowflake_outbound_share)
snowflake_outbound_share)Outbound shares are observed from the manually configured outbound shares list.
name
Share name.
type
Always snowflake_outbound_share.
subtype
Always outbound_share.
parent_container
Parent snowflake_account.
defines
Database URI shared by the outbound share, when Euno can match it to an observed database.
Hex project (hex_project)
hex_project)Hex projects can be observed from Snowflake query history when Hex usage or Hex lineage extraction is enabled. These observations enrich Hex project resources with Snowflake usage and lineage.
name
Hex project name, when available.
type
Always hex_project.
subtype
Always hex_project.
native_id
Hex project ID.
platform_uri_prefix
Snowflake URI prefix used to resolve table and column lineage.
table_dependencies
Snowflake table URIs used by the Hex project.
upstream_fields
Snowflake column URIs used by the Hex project.
total_queries_14d, total_queries_30d, total_queries_60d
Hex project query counts over the last 14, 30, or 60 days.
total_read_queries_14d, total_read_queries_30d, total_read_queries_60d
Snowflake read query counts attributed to the Hex project.
total_read_credits_14d, total_read_credits_30d, total_read_credits_60d
Snowflake read credits attributed to the Hex project.
total_read_cost_14d, total_read_cost_30d, total_read_cost_60d
Snowflake read cost attributed to the Hex project.
distinct_users_14d, distinct_users_30d, distinct_users_60d
Distinct Hex users over the last 14, 30, or 60 days.
queries_breakdown_by_user_14d, queries_breakdown_by_user_30d, queries_breakdown_by_user_60d
Query breakdown by Hex user.
used
Users who used the Hex project, with recent activity counts.
hex_project_latest_sql_by_cell
Latest observed SQL by Hex cell, used to derive lineage.
Relationships
database
has parent
snowflake_account
Databases are contained by the Snowflake account.
database_schema
has parent
database
Schemas are contained by databases.
table
has parent
database_schema
Tables, views, materialized views, and temporary tables are contained by schemas.
snowflake_semantic_view
has parent
database_schema
Semantic views are contained by schemas.
column
has parent
table
Columns are contained by tables and views.
snowflake_dimension, snowflake_metric
has parent
snowflake_semantic_view
Dimensions and metrics are contained by semantic views.
snowflake_inbound_share, snowflake_outbound_share
has parent
snowflake_account
Shares are contained by the Snowflake account.
table
has upstream
table
Table-level lineage from view definitions and Snowflake access history.
column
has upstream_fields
column
Column-level lineage from Snowflake access history.
snowflake_semantic_view
has upstream
table
Semantic views depend on their base Snowflake tables.
snowflake_dimension, snowflake_metric
has upstream_fields
column
Semantic view dimensions and metrics depend on Snowflake columns used in their expressions.
hex_project
has upstream
table
Hex projects depend on Snowflake tables referenced by Hex SQL.
hex_project
has upstream_fields
column
Hex projects depend on Snowflake columns referenced by Hex SQL.
snowflake_inbound_share, snowflake_outbound_share
defines
database
Shares define the databases they expose when Euno can match those databases.
snowflake_inbound_share
has upstream
snowflake_outbound_share
Matching inbound and outbound shares with the same name establish cross-account sharing lineage.
For setup details related to inbound and outbound shares, see Observing Snowflake Shares.
Last updated