Overview: Query Builder for Snowflake
How to access the Query Builder for Snowflake
Navigate to Metrics > Query Builder to access the Query Builder for Snowflake. Click the green + Create Custom Metric button and select your connected Snowflake Data Source from the Data Source drop-down list.
The ability to connect Snowflake and access Query Builder is available on the Professional and Performer plans. Request a free trial of Snowflake by following
How to use the Query Builder for Snowflake
How to create a Custom Snowflake Metric [Example]
The Query Builder for Snowflake is designed so you can directly enter SQL queries. For our example, we will use a Snowflake Data Source and create a Custom Metric that returns a list of Custom Names and their current Account Balance.
SELECT start_date AS date, name, balance FROM sample_data
If you don’t see any data, double check your SQL query and try it directly in your Database. If no results are displayed there, an error exists in your query. You should also check to confirm that the Snowflake user has the necessary permissions to access the Database from Databox's public IP.
How to add a Custom Snowflake Metric to a Databoard
Learn how to add a Custom Metric to a Databoard here.
- Query results are limited to 10,000 rows. If you expect your query to return over 10,000 rows or if you're not sure how many rows will be returned, be sure to LIMIT the query. If you need more than 10,000 rows in order to successfully report on your Snowflake data in Databox, feel free to submit your request on our Roadmap here.
- The query must contain a column named "Date." If you need to, use AS in your SELECT statement to satisfy this requirement
- One column should always contain the Metric Value
- "Null" values will not be recognized. Use a COALESCE function when needed. Learn more here.