Author: M Smith
Using SQL in Google Sheets
SQL is a great language for analysing and slicing and dicing data. The folks at Google who build Google Sheets appreciate this too. So much so that they have built …
Execute queries in BigQuery in parallel using python
An example of how to run multiple queries in parallel.
Copying BigQuery tables to a new dataset with bq command line tool
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 …
Using SQL in pandas with duckdb
A code snippet showing how to use SQL to query a pandas dataframe using duckdb. See this post by duckdb. SQL logic, functions and syntax fit my brain better than …
Simple logging to SQLite database from python
A lightweight example of saving some logs to an SQLite database in a python script.
Adding user login to Streamlit apps
A short guide to adding user authentication to Streamlit apps. So you’ve created a beautiful Streamlit app which your users love, but only certain people should be able to access …
From email to data warehouse – Google Edition
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 …