CLConstantin Lunguindatawise.dev·May 20 · 1 min readpre_ and post_operations in DataformHere's a useful Dataform concept: pre_operations and post_operations. As the name implies, these represent a set of actions that run before and after the main operation (table, view, or SQL operations10
CLConstantin Lunguindatawise.dev·May 15 · 2 min readBigQuery Object Tables: A Practical Introduction 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 da00
CLConstantin Lunguindatawise.dev·Apr 26 · 4 min readBigQuery BigLake Tables Explained: What They Are and When to Use ThemIf 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, Goog00
CLConstantin Lunguindatawise.dev·Mar 5 · 1 min readBigQuery Saves Your Query Results — Here's How to Find ThemEver 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 automa00
CLConstantin Lunguindatawise.dev·Feb 7 · 1 min readParameters in BigQueryYou 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 place00
