Tim's BigQuery blog

It has been a considerable period since my last journal entry. Following my previous update, I embarked on a new professional endeavor,...

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...

It's no secret that I prefer simple, cheap, and built-in solutions over costly, complicated and heavy approaches. I've got a few reasons...

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

I've seen countless situations in which a developer begins coding a data integration routine without planning and without performing the...

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

At times, you'll find yourself in need of comparing the data within two tables. Often, this comes during times of migrating legacy ETL...

Moving from a traditional, mature data warehouse can be the perfect time to restore and rebuild your data warehouse schema to something...

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

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...

Example code for this blog entry As a column-store, cloud data warehouse, BigQuery does not support primary keys, unique keys, or foreign...

There's information out there in the wild indicating that best practices for Google BigQuery involves using nesting and repeated columns...