@cnstlungu

BigQuery Object Tables: A Practical Introduction

2d ago · 2 min read · BigQuery has always been a SQL engine for tabular data. Object tables add an interesting twist to that. Instead of rows containing values, an object table gives you one row per file — pointing at da

BigQuery BigLake Tables Explained: What They Are and When to Use Them

Apr 26 · 4 min read · If you've worked with BigQuery external tables before, you know the basic idea: a thin wrapper around data that resides somewhere else, but queryable from BigQuery. Sources include Cloud Storage, Goog

BigQuery Saves Your Query Results — Here's How to Find Them

Mar 5 · 1 min read · Ever run a heavy BigQuery SQL query, processed gigabytes of data — and then accidentally closed the tab or forgot to save the results? 😬 Don't re-run it. Your results are still there. BigQuery automa

Parameters in BigQuery

Feb 7 · 1 min read · You can use query parameters in BigQuery hashtag#SQL (now in the console as well!) — but how are they different from variables, and when should you use each? Both parameters and variables act as place

Flattening JSON arrays in BigQuery

Dec 7, 2025 · 1 min read · I've noticed that a new JSON function has been added (in Preview) in BigQuery SQL - JSON_FLATTEN(). It allows us to flatten JSON arrays and return a single flat ARRAY, no matter how many nested levels there are. So where is this actually useful?➡️ Ha...