Build SQL queries in Snowflake
Build SQL queries in Snowflake
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:
- SQL expressions reference (dimensions)
- SQL expressions reference (metrics)
- Use date and time in SQL queries
- Use filters in SQL queries
- Build metric cards
- Metric card example
- Build visit cards
- Visit card example
- Calculated metric card example
- Retrieve a card summary
- Retrieve trend data
- Build a view events report
|
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. |
Very useful
Not really
Very useful
Not really