I’m continuing to enjoy the relaxed abilities that BigQuery brings compared to other common databases. However, yesterday I was bitten by how relaxed it can be. I had been refactoring an existing scheduled query & as part of it, I had been (manually) converting many of the reserved words in ALL CAPS. Well, I had […]
Tag: BigQuery
Today I Learned: BigQuery Scheduled Queries Edition
Today I learned to never, ever assume that any scheduled queries written & deployed by someone else won’t be contradicted by that same person in another scheduled query. If you find a scheduled query (don’t use them, just don’t…) that populates a table but produces a result different than what you expect (read: has significantly […]