PinnedInData Science CollectivebyMartin Weitzmann·Sep 8, 2025Why your Inner Joins produce unexpected duplicatesNo duplicates should be unexpected. If this headline spoke to you, we need to urgently correct your mental model of joins — let’s go!
PinnedInTDS ArchivebyMartin Weitzmann·Jul 24, 2019BigQuery: SQL on Nested DataBigQuery can be very powerful because nested data means working on pre-joined tables. But analysts struggle to use its full potential …A response icon4A response icon4
PinnedInTDS ArchivebyMartin Weitzmann·Oct 14, 2022BigQuery SQL Optimization 2: WITH Temp Tables to Fast ResultsWhen to use Temporary Tables instead of WITHA response icon4A response icon4
InTDS ArchivebyMartin Weitzmann·Mar 26, 2024De-Nesting Google Analytics Data in BigQueryThe proper way to flat tablesA response icon1A response icon1
Martin Weitzmann·Feb 4, 2023BigQuery: SQL auf Daten-NesternAnalysen in Google BigQuery können sehr viel schneller sein als in anderen Systemen. Das liegt an den Arrays, die dort bevorzugt verwendet…
InTDS ArchivebyMartin Weitzmann·Feb 1, 2023BigQuery Optimization Strategies 3: Table FlatteningAbout Exploding Tables and Imploding ArraysA response icon1A response icon1
InTDS ArchivebyMartin Weitzmann·Sep 7, 2022BigQuery SQL Optimization 1: Filter as Early as PossibleLet’s talk about low performing SQL and how to use and optimize filters with WHERE, HAVING, and QUALIFY in flat and nested data …
InTDS ArchivebyMartin Weitzmann·Aug 17, 2022Explain SQL Joins the Right WayThis article takes the perspective of someone who needs to introduce people to the concept of Joins in databases, e.g. LEFT JOIN. This can…A response icon2A response icon2
InTDS ArchivebyMartin Weitzmann·Jun 22, 2020BigQuery: Creating Nested Data with SQLWorking with SQL on nested data in BigQuery can be very performant. But what if your data comes in flat tables like CSV’s?A response icon3A response icon3
InTDS ArchivebyMartin Weitzmann·Apr 28, 2020Google Analytics in BigQuery 1: Getting StartedHere, I will show you on open data how to get started with Google Analytics tables in BigQuery. I’ll cover what the structure looks like…A response icon1A response icon1