> For the complete documentation index, see [llms.txt](https://docs.espresso.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.espresso.ai/snowflake-optimizer/snowflake-metadata.md).

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