Analytical – Honest – Passionate
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 …
Exporting to csv manually then opening with Google Sheets is now a thing of the past with Connected sheets functionality. Connected sheets is the functionality within Google Sheets to directly …
The UNNEST function in BigQuery is used to transform arrays or repeated fields within a table into individual rows. This is particularly useful when dealing with data stored in nested …
Video Tutorials 30 days of Streamlit Build a different Streamlit app each day for 30 days https://blog.streamlit.io/30-days-of-streamlit/ Streamlit documentation Offical Streamlit documentation. Very user friendly and accessible reference materials. https://docs.streamlit.io/library/get-started …
A short guide for deploying a Streamlit app to Cloud Run on Google Cloud platform. Google Cloud Run is a managed platform for hosting and running docker containers. So once …