Access your local home automations on the go by assigning a static domain name to your dynamic home IP address. — Google Domains has been a great place to manage all of my registered domains names. While there are several well-established free and paid dynamic dns services — of some which require technical knowledge or complicated setup — Google Domains supports dynamic dns natively and easily (and for free) using either…

Admittedly, I am way too excited about stumbling upon this tool while researching another project. As I’ve gotten along in may career, I find myself at the CLI less and less. …

Lessons learned connecting BigQuery to data sources in Google Sheets. APIs and tools change over time. Future-proof your integrations to protect against unintended consequences. — The ability to connect BigQuery to Google Sheets as a data source may be one of the most powerful, yet underutilized features for quickly and easily integrating small data into your enterprise data warehouse. …

Using a Raspberry Pi to interact with your Google Cloud Platform projects without having to expose your user credentials. — Install the Google Cloud SDK on a Raspberry Pi to access and interact with your Google Cloud Platform projects via a Service Account. In this example, we’ll create a Service Account with access to load speedtest result data into Google BigQuery. Create the Service Account Google Cloud official documentation for creating service accounts.

I’ve been working on a few home automation projects using historical weather data from the Big Query NOAA Public Weather Dataset to schedule automations, estimate energy usage, or predict when I’ll get my next home heating oil delivery. …

Google Sheets, Big Query, and Public Data Sets — Calculating Degree Days and K-Factor. Have you ever wondered how home heating fuel companies know when to make a delivery? Even if you don’t get propane or home heating oil deliveries, you can still estimate your fuel usage over time by…

Use BigQuery Public Datasets, Geography Functions, Wildcard Tables, and ARRAY_AGG & UNNEST to locate and query local historical weather data near any address. While working on a smart home data project, I found myself searching for public weather data. It turns out that Google BigQuery has a ton of weather…

With the sudden shift to remote learning in the spring due to COVID-19, Students and Educators were left scrambling to find ways to salvage the remainder of the school year. …