TLDR — I really like this machine, it is portable, fast, quiet, and comfortable to work on for hours at a time. When I read about Apple’s announcement of the new M1 MacBook Pro featuring the Apple M1 Chip, I must admit, it made me a bit excited about Macs…

TLDR — It is now possible to create integer partitioned tables in BigQuery. This post will talk about what that means, how to leverage it, and finally walk through a few scenarios demonstrating the benefits of it. If you weren’t paying close attention to the latest GCP announcements, you may…

TLDR — If you are looking for an easy way to query a public dataset, you should definitely check out Big Query’s publicly available datasets, and chances are you will find the dataset you are looking for. Background Late one Sunday afternoon, I found myself browsing around a few high profile…

TLDR — In this post I will walk through how to use BigQuery’s new capability of querying Hive Partitioned Parquet files in GCS. It is a really cool feature.. I have a huge interest in Data Lakes, especially when it comes to the query engines that are capable of querying…