TCH HUM MKT AI CO Constantin Lungu · Data Engineer’s Notes BigQuery Object Tables: A Practical Introduction BigQuery has always been a SQL engine for tabular data. Object tables add an interesting twist to that.
CO Constantin Lungu · Data Engineer’s Notes 9 tips on writing cleaner SQL Structured Query Language, widely recognized by its acronym SQL (whether you pronounce it as es-queue-el or sequel), is one of the most…
TCH MKT CO Constantin Lungu · Data Engineer’s Notes Optimizing SQL queries in BigQuery When it comes to tuning a #SQL query in #BigQuery for top performance and cost-efficiency, here’s my starting point:
AI TCH MKT CO Constantin Lungu · Data Engineer’s Notes Here’s a great use case for GenAI writing SQL Truth be told, I almost never use GenAI as part of my day-to-day work as a Data Engineer. For the most part, it’s just easier and faster…
TCH MKT AI CO Constantin Lungu · Data Engineer’s Notes Loading data from Google Cloud Storage into BigQuery using Cloud Workflows Google Cloud Workflows is a serverless orchestration platform that allows us to combine services into repeatable and observable sets of…
ECO TCH MKT CO Constantin Lungu · Data Engineer’s Notes Scheduled queries in BigQuery Scheduled Queries in BigQuery allow users to run SQL tasks on a predefined, automated schedule.
TCH MDA CO Constantin Lungu · Data Engineer’s Notes BigQuery BigLake Tables Explained: What They Are and When to Use Them If you’ve worked with BigQuery external tables before, you know the basic idea: a thin wrapper around data that resides somewhere else, but…
MKT CO Constantin Lungu · Data Engineer’s Notes A few thoughts about recent Python integration into Excel The buzz is real! Excel now integrates with Python, and it’s making waves.
TCH MKT CO Constantin Lungu · Data Engineer’s Notes BigQuery Saves Your Query Results — Here’s How to Find Them Ever run a heavy BigQuery SQL query, processed gigabytes of data — and then accidentally closed the tab or forgot to save the results? 😬
TCH CO Constantin Lungu · Data Engineer’s Notes pre_ and post_operations in Dataform Here’s a useful Dataform concept: pre_operations and post_operations. As the name implies, these represent a set of actions that run before…
