BigQuery SQL

Screenshot-2023-04-17-at-7.36
How to Make a BigQuery Real-Time MTD Job Cost Monitoring Dashboard (Part 1): Setting Up the Data
April 17, 2023
8:55 am
Vonn
,
In this part 1 post, we’ll go over Setting Up the Data: Creating a Sink: How to get BigQuery...
When to Use IF NULL THEN 0 (How to Handle Null Values in SQL)
When to Use IF NULL THEN 0 (How to Handle Null Values in SQL)
March 15, 2023
10:00 am
Vonn
A couple of questions I’ve always had are: How are nulls handled and calculated when performing...
GA4 & BigQuery: A SQL Model for a Base Events Table (How to Unnest Fields)
GA4 & BigQuery: A SQL Model for a Base Events Table (How to Unnest Fields)
March 14, 2023
10:00 am
Vonn
,
Introduction to GA4 Public Dataset in BigQuery In this post, we’ll be using the GA4 public dataset...
GA4 & BigQuery: Benefits, Drawbacks, and Cost
GA4 & BigQuery: Benefits, Drawbacks, and Cost
March 13, 2023
8:00 am
Vonn
,
In this post, we’ll provide a primer on BigQuery and GA4, why it’s beneficial, what are its...
5 Learnings From Creating a Sessions Fact Table From GA4 Data in BigQuery SQL
5 Learnings From Creating a Sessions Fact Table From GA4 Data in BigQuery SQL
March 8, 2023
9:21 am
Vonn
,
With the new Google Analytics and Google’s decision to allow a direct integration between GA4 and...
BigQuery SQL & GA4: How to Query Multiple Tables Using _TABLE_SUFFIX
BigQuery SQL & GA4: How to Query Multiple Tables Using _TABLE_SUFFIX
January 20, 2023
10:02 am
Vonn
,
Select From All Tables SELECT * FROM `bigquery-public-data.ga4_obfuscated_sample_ecommerce.events_*`...
  • Browse All Categories
Beginner Data Engineering
GA4
BigQuery SQL
Python
  • Trending Posts
How to Export Your Universal Analytics (GA3) Data the Fastest & Easiest Way [w/ Free Templates Included]
May 6, 2024
1:26 pm
Vonn
A Beginner Data Engineer Project: Extract Random Jokes via API with Python (Part 2)
September 29, 2023
10:13 am
Vonn
A Beginner Data Engineer Project: Extract Random Jokes via API with Python (Part 1)
September 27, 2023
10:30 am
Vonn
What Are Python Lambda Functions?
September 14, 2023
3:54 pm
Vonn
How to Make a BigQuery Real-Time MTD Job Cost Monitoring Dashboard (Part 1): Setting Up the Data
April 17, 2023
8:55 am
Vonn
3 Things You Need to Get Paid More
April 6, 2023
10:10 am
Vonn
How to Connect BigQuery with dbt
March 29, 2023
10:00 am
Vonn
How to Model GA4 Data Easier in BigQuery with this Helpful Tool
March 24, 2023
10:00 am
Vonn
When to Use IF NULL THEN 0 (How to Handle Null Values in SQL)
March 15, 2023
10:00 am
Vonn
GA4 & BigQuery: A SQL Model for a Base Events Table (How to Unnest Fields)
March 14, 2023
10:00 am
Vonn