---
title: Build SQL queries in Snowflake
slug: n21e0337
canonical_url: https://docs.coveo.com/en/n21e0337/
collection: coveo-analytics
source_format: adoc
---
# Build SQL queries in Snowflake
As an administrator or analytics manager, you can retrieve [Coveo Analytics data](https://docs.coveo.com/en/259/) with SQL queries to create your own reports. You can also verify the results against Coveo [reports](https://docs.coveo.com/en/266/) or those generated through third-party business intelligence (BI) or extract, transform, and load (ETL) tools.
Since Coveo uses the [Snowflake Database](https://docs.coveo.com/en/l9e90297/) to store your [organization](https://docs.coveo.com/en/185/)'s data, SQL queries retrieve your data directly from Snowflake, either through the [reader account](https://docs.coveo.com/en/l9e90297/) or through [data share](https://docs.coveo.com/en/m1rf0146/).

The following articles are a comprehensive reference of SQL expressions that can be used as building blocks to query your Coveo Analytics data:

- [SQL expressions reference (dimensions)](https://docs.coveo.com/en/n1cd0393/)
- [SQL expressions reference (metrics)](https://docs.coveo.com/en/mcge0079/)
- [Use date and time in SQL queries](https://docs.coveo.com/en/n23f0266/)
- [Use filters in SQL queries](https://docs.coveo.com/en/n2oa7409/)
- [Build metric cards](https://docs.coveo.com/en/n29g0464/)
- [Metric card example](https://docs.coveo.com/en/n2sg3042/)
- [Build visit cards](https://docs.coveo.com/en/n3vf0441/)
- [Visit card example](https://docs.coveo.com/en/n5th0332/)
- [Calculated metric card example](https://docs.coveo.com/en/n62d0198/)
- [Retrieve a card summary](https://docs.coveo.com/en/n6je0405/)
- [Retrieve trend data](https://docs.coveo.com/en/n77d8110/)
- [Build a view events report](https://docs.coveo.com/en/n81g0178/)
> **Important**
>
> * The reference information in this section is provided as a guideline for building SQL queries.
> It doesn't guarantee identical results to the ones retrieved using third-party BI or ETL tools since there may be subtle differences in how the queries are built.
> 
> * The SQL queries in this section are based on the Coveo UA Protocol.
> If you're using the Event Protocol, it should be noted that custom fields have been replaced by predefined events and dimensions.
> To learn more, see [Event Protocol](https://docs.coveo.com/en/o1n91230/).