/
SQL Library
SQL Library
- Devan Robertson
Owned by Devan Robertson
Below you'll find SQL queries that can be used to gather data and answer questions. These queries are written in Snowflake and can be used there "as-is" if your organization is a data consumer of our Snowflake data warehouse. However, they can also be used as a jumping off point for queries in your own database that contains QFD data.
It is important that you always include tenantID in your WHERE clause. Not doing so will result in poor performance.
WHERE tenantid = 'YOURTENANTIDHERE'
, multiple selections available,
Related content
Snowflake Tables & Views
Snowflake Tables & Views
More like this
Data Retention and Reporting
Data Retention and Reporting
Read with this
Reporting
Reporting
More like this
Chargebacks
Chargebacks
Read with this
Customer Lookup
Customer Lookup
More like this
Creating a Business Event Warehouse
Creating a Business Event Warehouse
Read with this