# Snowflake Metadata

Espresso will *never* access your Snowflake data.\
\
Most customers, including public companies, are comfortable sharing all of the below data under NDA.

#### Query History

We read Snowflake's [query history](https://docs.snowflake.com/en/sql-reference/functions/query_history) table to understand what workloads you're running and when, as well as statistics about those workloads (e.g. runtime, time in queue, bytes scanned).\
\
This table contains user-generated query text. If your query text is sensitive, we're happy to sign an NDA or a BAA before sharing data. We can also remove query text from the data we collect when we generate a savings estimate upon request.\
\
All other data in this table is machine-generated.

#### Query Attribution History

This table gives a per-query breakdown of compute costs.

#### Warehouse Event History

This table logs warehouse events, such as warehouses turning on and off and clusters spinning up and down.

#### **Rate Sheet Daily** **Contract Items**

These tables contains Snowflake contract information. We use them to calculate financial projections and to let you know if you're on track with your committed spend. We can remove them from the data we collect for a savings estimate upon request.

#### **Warehouse Metering History** **Metering Daily History** **Remaining Balance Daily**

These tables store hourly credit usage broken down by warehouse and daily credit usage, respectively. We use then to tune our models for new accounts and to check for outliers and certain edge cases.

#### Warehouse Settings

This lists your warehouses and their settings (e.g. size, type).

#### Current Account ID

This is your Snowflake's account ID. We use it to uniquely identify your account.

<br>


---

# 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.espresso.ai/snowflake-optimizer/snowflake-metadata.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.