SQL Library

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'