The first thing I do when analyzing a SQL table
C
Senior Data Engineer • Contractor / Freelancer • GCP & AWS Certified
Command Palette
Search for a command to run...
Comments
Join the discussionNo comments yet. Be the first to comment.
Practical SQL
Part 43 of 50
Short, practical posts on SQL and BigQuery — from core language features to advanced query patterns. A reference for data practitioners at every level.
How LIMIT helps you save time in BigQuery
Here's a basic thing that can save you a bit of time when analyzing data or validating data transformations. So I've previously posted about how in BigQuery using LIMIT for query output does not yield any cost saving as it has no effect on amount on ...
More from this blog
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 and after the main operation (table, view, or SQL operations
May 20, 20261 min read
BigQuery 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 da
May 15, 20262 min read
BigQuery BigLake Tables Explained: What They Are and When to Use Them
Query your data lake with warehouse-grade security and performance — without moving a single file.
Apr 26, 20264 min read
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? 😬 Don't re-run it. Your results are still there. BigQuery automa
Mar 5, 20261 min read
Parameters in BigQuery
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
Feb 7, 20261 min read
