Updating your application to migrate from Legacy to Standard SQL isn't a straightforward process of replacing colons with dots and…
Cross Region Migration of GA360
Google Analytics 360 offers a way to be able to track website traffic and, by using its BigQuery integration, store…
Introducing column based partitioning in BigQuery
Some background When we started using Google BigQuery - almost five years ago now - it didn't have any partitioning…
TEL Newsletter – February 2018
Shine’s TEL group was established in 2011 with the aim of publicising the great technical work that Shine does, and to raise…
Trams, Shiners and Googlers!
Shine's good friend Felipe Hoffa from Google was in Melbourne recently, and he took the time to catch up with…
The best code is no code! Using Google Cloud’s new automated services.
Here in Australia, we do a lot of work on Google Cloud Platform for one of the country’s largest ISPs,…
Read More The best code is no code! Using Google Cloud’s new automated services.
Scheduling BigQuery jobs: this time using Cloud Storage & Cloud Functions
Intro Post update: My good friend Lak over at Google has come up with a fifth option! He suggests using…
Read More Scheduling BigQuery jobs: this time using Cloud Storage & Cloud Functions
TEL Newsletter – December 2017
Shine’s TEL group was established in 2011 with the aim of publicising the great technical work that Shine does, and to raise…
Fun with Serializable Functions and Dynamic Destinations in Cloud Dataflow
Do you have some data that needs to be fed into BigQuery but the output must be split between multiple destination…
Read More Fun with Serializable Functions and Dynamic Destinations in Cloud Dataflow
Scheduling BigQuery jobs using Google Apps Script
Do you recoil in horror at the thought of running yet another mundane SQL script just so a table is…