# 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. |

{% hint style="warning" %}
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`.
{% endhint %}

#### 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. |

{% hint style="info" %}
For setup details related to inbound and outbound shares, see [Observing Snowflake Shares](/sources/data-warehouses/snowflake-integration/observing-snowflake-shares-and-cross-snowflake-account.md).
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.euno.ai/sources/data-warehouses/snowflake-integration/snowflake-integration-discovered-resources.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.