Analytical – Honest – Passionate
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 …
Important and valuable data is often kept in Google Sheets. Learn how to make use of this data from within BigQuery in this post. Google sheets is a very useful …