Analytical – Honest – Passionate
A code snippet showing how to trigger a DAG in Cloud Composer (managed Airflow) using the gcloud command line tool.
A collection of video resources to on using and understanding SQLite. SQLite case study SQLite with Python SQLite for beginners …although some of the topics don’t seem like beginner topics …
Different approaches to load data into a SQLite database using the following Python libraries: Pandas Using the pandas library (alongside click, and uv) to load a csv file into a …
Working with data involves handling a lot of data files, most commonly CSV files. It can be very helpful to do some exploratory data analysis on the CSV file to …
In BigQuery when running a query, the costs associated with doing so include a “scan” of the data that may be processed as part of executing the query. For example, …
A code sample to create a random forest machine learning model in BigQuery and make predictions all using SQL.
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