MarquinSmith

Analytical – Honest – Passionate

  • Home
  • Services
  • Mini Projects
    • Data Analytics Helper Tools
    • Bitcoin Price Dashboard
    • Journey to data engineering
    • Tarantino Film Dashboard
    • Woolworths stock price tracker
    • How to reason and argue
  • Reference
    • The BookShelf
    • SQL Cheat Sheet
    • Dockerfile Cheat Sheet
  • Health, fitness and wellbeing
    • Crossfit Workouts
    • Gymnastics
    • Strength and fitness masterclass
    • Nutrition Course
    • Workout Stats
    • Physical Activity Stats
    • 6 week pre season soccer fitness plan
  • About

Category: Automation

Automation

A python command line tool to create dates in a range

26th June 202525th June 2025 M SmithLeave a comment

A simple tool to create dates in a date range at the terminal. Each date in the date range is printed to the screen allowing for redirection or incorporation into …

Read More ›
Automation

Trigger an Airflow DAG in Google Cloud Composer using gcloud command line tool

25th June 2025 M SmithLeave a comment

A code snippet showing how to trigger a DAG in Cloud Composer (managed Airflow) using the gcloud command line tool.

Read More ›
Automation

Loading data into SQLite

23rd June 202523rd June 2025 M SmithLeave a comment

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 …

Read More ›
Automation

A command line tool to get csv summaries using Sweetviz

22nd June 2025 M SmithLeave a comment

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 …

Read More ›
Automation

List users who have access to a dataset in BigQuery

18th June 202518th June 2025 M SmithLeave a comment

Use the bq command line tool to list the users who have access to a particular dataset in BigQuery

Read More ›
Automation

Set expiration table on existing Bigquery tables

11th June 202511th June 2025 M SmithLeave a comment
Read More ›
Automation

Running Python scripts using UV

6th March 20256th March 2025 M SmithLeave a comment

In case you haven’t heard, UV is a relatively new python package and project manager. UV allows for you to define package dependencies and the Python version to run the …

Read More ›
Automation

Running SQL Queries on a schedule in BigQuery | Part 2b: Cloud Functions

4th February 20254th February 2025 M SmithLeave a comment

In this part of the series we will walkthrough how to set up a query to run at a regular interval using Python and Cloud Functions. This is useful particularly …

Read More ›
Automation

A Dockerfile to create a docker image to run a python file

10th January 202510th January 2025 M SmithLeave a comment

Use this Dockerfile as a template to be able to create docker images that will execute a python script once the container is run. This can be very useful if …

Read More ›

Posts pagination

1 2

Recent Posts

  • A command line tool to compare 2 different csv files – sweetviz edition
  • Bots arrive on marquinsmith.com
  • Physical Health Tracker – October 2025
  • Jeff Booth conversation on Simply Bitcoin
  • A `.sqlfluff` settings file I like

Categories

  • Automation
  • Business
  • cybersecurity
  • Data Analysis
  • Finance
  • Personal Development
  • Python
  • Uncategorised
  • Web Analytics

Archives

Copyright © 2025 MarquinSmith.
Theme Easthill by ThemeMunk. Powered by WordPress.