Web development concept with person holding a white smartphone_edited.jpg

Tim's BigQuery blog

Ideas, tips and tricks

Home: Welcome

Aug 18, 20224 min read

My thoughts on Airbyte

What a great time to be alive in the data space. There are a plethora of data tools out there to make our jobs easier, at least in most...

Jul 23, 20227 min read

BigQuery vs. Snowflake showdown

As someone who regularly uses both BigQuery and Snowflake, there are aspects in each tool that behave differently, or that provide either...

Jul 12, 20222 min read

Creating random values in a normal distribution in BigQuery

Some languages, such as R, have built in functionality to pull random numbers from a normal distribution. Other languages and...

Jun 11, 20223 min read

Predictive modeling workflow in BigQuery vs. R Studio pt. 1: ad-hoc modeling

One of the advantages of BigQuery over other cloud data warehouses is the inclusion of machine-learning models within the SQL syntax. In...

Jun 6, 20224 min read

Refactoring BigQuery public datasets pt. 1: nested and repeated in FDA food_events

Data munging is one of the most time consuming exercises in the data analysis process. It's not unheard of to spend 90% of the effort in...

Home: Blog2

About me

I've been working with and building data warehouses for almost twenty years. In 2021, I began working with Google BigQuery, due to it's simplicity and low barrier of entry. This blog is from the perspective of moving from a traditional data warehouse to GBQ.

Home: About Me

Let’s Connect

Home: Contact