Snowflake Integration Discovered Resources

Ingested Resources & Properties

Snowflake account (snowflake_account)

The Snowflake account is the top-level Snowflake resource observed by the integration.

Property	Description
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)

Snowflake databases are observed as container resources.

Property	Description
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)

Snowflake schemas are observed as container resources under databases.

Property	Description
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)

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.

Property	Description
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:

Property	Description
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)

Snowflake table and view columns are represented as column resources.

Property	Description
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 views are observed when semantic view discovery is enabled.

Property	Description
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 dimensions are child resources of a Snowflake semantic view.

Property	Description
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 metrics are child resources of a Snowflake semantic view.

Property	Description
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)

Inbound shares are observed when Observe inbound Snowflake shares is enabled.

Property	Description
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)

Outbound shares are observed from the manually configured outbound shares list.

Property	Description
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 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.

Property	Description
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

Source type(s)	Relationship	Target type(s)	Notes
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.