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

Author: M Smith

Personal Development

Physical Health Tracker – May 2024

29th June 202429th June 2024 M SmithLeave a comment
Read More ›
Data Analysis

Running SQL Queries on a schedule in BigQuery | Part 1: Scheduled Queries

28th June 202428th June 2024 M SmithLeave a comment

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 …

Read More ›
Personal Development

Physical Health Tracker – April 2024

12th May 202412th May 2024 M SmithLeave a comment
Read More ›
Personal Development

Physical Health Tracker – March 2024

12th May 202412th May 2024 M SmithLeave a comment
Read More ›
Data Analysis

Query Google Sheets from BigQuery

31st March 202431st March 2024 M SmithLeave a comment

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 …

Read More ›
Data Analysis

Query BigQuery from Google Sheets

3rd March 20243rd March 2024 M SmithLeave a comment

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 …

Read More ›
Personal Development

Physical Health Tracker – February 2024

2nd March 20242nd March 2024 M SmithLeave a comment
Read More ›
Data Analysis

Last modified BigQuery table datetime

24th February 202414th August 2024 M SmithLeave a comment
Read More ›
Personal Development

Physical Health Tracker – January 2024

9th February 20249th February 2024 M SmithLeave a comment
Read More ›
Data Analysis

SQL Query for exits on Adobe Analytics click stream data

29th January 202429th January 2024 M SmithLeave a comment
Read More ›

Posts pagination

1 … 3 4 5 6 7 8 9 … 15

Recent Posts

  • How to revoke read access to a single table in BigQuery using SQL
  • How to grant read access to a single table in BigQuery using SQL
  • Copy a BigQuery model into another dataset using bq command line tool
  • A python command line tool to create dates in a range
  • Trigger an Airflow DAG in Google Cloud Composer using gcloud command line tool

Categories

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

Archives

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