Build SQL queries in Snowflake

This is for:

As an administrator or analytics manager, you can retrieve Coveo Usage Analytics (Coveo UA) data with SQL queries to create your own reports. You can also verify the results against Coveo reports or those generated through third-party business intelligence (BI) or extract, transform, and load (ETL) tools. Since Coveo uses the Snowflake Database to store your organization's UA data, SQL queries retrieve your data directly from Snowflake, either through the reader account or through data share.

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

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