Analytical – Honest – Passionate
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 …
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 …
A lightweight example of saving some logs to an SQLite database in a python script.
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 …
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 …