BigQuery time travel is pretty neat
SELECT * FROM `mydataset.mytable` FOR SYSTEM_TIME AS OF TIMESTAMP_SUB ( CURRENT_TIMESTAMP (), INTERVAL 1 HOUR ); That query allows you to get data fro…
Latest News
⚑ Report a ProblemTech news from the best sources
All topics
AI
Gear
News
Tech
agents
ai
api
architecture
automation
beginners
career
database
devchallenge
devops
discuss
javascript
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
react
security
showdev
tutorial
typescript
webdev
Deeper into Dataform 3: Auditing Dataform
It's important to monitor Dataform - jobs executed by Dataform can be the primary source of BigQuery costs in a modern data platform. Forgetting to in…
Fixing Google BigQuery Auth Proxying
TL;DR builder.Credential = credential; - Fails to route authentication traffic through the proxy. builder.GoogleCredential = credential; - Successfull…
How to Optimize BigQuery Costs (Real Techniques That Work)
I want to start with a number: $140,000 . That's how much a single misconfigured scheduled query cost one of the teams I worked with over a three-mont…