spectacles
spectacles copied to clipboard
Adding context to failing SQL files
It would be useful to add additional context to the files that store the failing SQL. As an example:
/*
The Google BigQuery Standard SQL database encountered an error while running
this query. Failed to retrieve data - Name numbers_of_orders not found inside
dim_customers at [3:23]
LookML: https://spectacles.looker.com/projects/jaffle_shop/files/views%2Fdim_customers.view.lkml?line=46
Query executed at 2020-04-09 22:24:19T00:00
*/
SELECT
dim_customers.numbers_of_orders AS dim_customers_number_of_orders
FROM analytics.fct_orders AS fct_orders
LEFT JOIN analytics.dim_customers AS dim_customers ON fct_orders.customer_id = dim_customers.customer_id
WHERE 1 = 2
GROUP BY 1
ORDER BY 1
LIMIT 0
Currently, these files only contain the SQL itself.