spectacles icon indicating copy to clipboard operation
spectacles copied to clipboard

Adding context to failing SQL files

Open DylanBaker opened this issue 5 years ago • 0 comments

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.

DylanBaker avatar Apr 15 '20 20:04 DylanBaker