Analytical – Honest – Passionate
A short code example which loads a csv file from Google Cloud Storage into a table using SQL.
Use the bq command line tool to list the users who have access to a particular dataset in BigQuery
In this part of the series we will walkthrough how to set up a query to run at a regular interval using Python and Cloud Functions. This is useful particularly …
For a little while now I have been using a personal health tracking tool to monitor my progress in various areas such as strength exercises, weight management and mental hygiene …
A code example for how to write BigQuery SQL to export a table to Google Cloud Storage in csv and parquet file formats. Parquet CSV
An example of how to run multiple queries in parallel.
With the bq command line tool moving multiple tables at a time from one BigQuery dataset to another can be done with a few lines of code. The tool can …
Use the Google technology stack to automatically load csv files received over email into BigQuery. In the data world, sending data over email is something that has been around for …
A short walkthrough guide of setting up a scheduled query in BigQuery. The Google documentation for scheduled queries is here. Step 1: Create a query in the bigQuery interface that …