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: Data Analysis

Automation

A `.sqlfluff` settings file I like

26th October 202526th October 2025 M SmithLeave a comment

When using SQLfluff to format sql files it is possible to set certain formatting rules that should be followed when formatting the the files. These rules can be specified in …

Read More ›
Automation

Setting up sqlfluff as a pre commit hook using UV

23rd October 202523rd October 2025 M SmithLeave a comment

SQL is a very flexible language when it comes to formatting. As long as the commands and syntax are in the right order then the SQL query will work. Whitespace …

Read More ›
Automation

A command line tool to compare 2 different csv files

20th September 202520th September 2025 M SmithLeave a comment

Below is a python script that uses the ydata-profiling library to create a report that compares two csv files. This is proving useful in verifying the similarity between original and …

Read More ›
Data Analysis

Calculate a reasonable daily usage quota for BigQuery

28th July 202528th July 2025 M SmithLeave a comment

A previous post showed how to set a ‘daily query usage‘ quota in BigQuery, and what that quota should be to stay within the free tier of BigQuery. Well, what …

Read More ›
Data Analysis

Set a daily query usage quota in BigQuery

23rd July 202523rd July 2025 M SmithLeave a comment

In BigQuery there is a free tier for querying data. As long as less than 1 tebibyte of data is queried in a month there are no charges associated with …

Read More ›
Data Analysis

All roads lead to SQLite

1st July 20251st July 2025 M SmithLeave a comment

SQLite is a great choice for doing data analytics locally. SQLite is a robust database that has been battle tested for over a decade. It is a single file which …

Read More ›
Data Analysis

The Nature of code genetic algorithm videos

30th June 202530th June 2025 M SmithLeave a comment

Videos about genetic algorithms from the Nature of Code playlist from “The Coding Train” YouTube channel. Nature of Code genetic algorithm section.

Read More ›
Automation

How to revoke read access to a single table in BigQuery using SQL

29th June 202528th June 2025 M SmithLeave a comment

If a particular user has been added read access to a table these permissions can be removed using the REVOKE keyword in SQL:

Read More ›
Data Analysis

How to grant read access to a single table in BigQuery using SQL

28th June 202528th June 2025 M SmithLeave a comment

A code snippet to add a user as read only on a BigQuery table. To add different permissions, other BigQuery roles can be seen in the Google documentation.

Read More ›
Automation

Copy a BigQuery model into another dataset using bq command line tool

27th June 202527th June 2025 M SmithLeave a comment

When creating or building a BigQuery Machine Learning model, the model itself is stored inside a BigQuery dataset. The code snippet below shows how to move a model from one …

Read More ›

Posts pagination

1 2 3 4 … 6

Recent Posts

  • Jeff Booth conversation on Simply Bitcoin
  • A `.sqlfluff` settings file I like
  • Setting up sqlfluff as a pre commit hook using UV
  • Physical Health Tracker – September 2025
  • Physical Health Tracker – August 2025

Categories

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

Archives

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