upstream-prod icon indicating copy to clipboard operation
upstream-prod copied to clipboard

BigQuery breaks in `get_table_update_ts` due to missing backticks

Open davidwitk opened this issue 8 months ago • 0 comments

get_table_update_ts.sql queries the information schema several times, for example here:

https://github.com/LewisDavies/upstream-prod/blob/acbb79be52376c0ce38fb102f47ff11bc7918d33/macros/get_table_update_ts.sql#L13

The queries fail on BigQuery because it expects backticks. For example, changing

{{ relation.database }}.information_schema.tables

to

`{{ relation.database }}.information_schema.tables`

does the fix. I guess one way to handle this could be to handle BigQuery in a separate condition?

davidwitk avatar Jun 07 '24 12:06 davidwitk