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

Tag: Google Cloud Platform

Data Analysis

A personal health tracking tool

6th December 20246th December 2024 M SmithLeave a comment

For a little while now I have been using a personal health tracking tool to monitor my progress in various areas such as strength exercises, weight management and mental hygiene …

Read More ›
Data Analysis

Export BigQuery table to Google Cloud Storage

10th October 202415th October 2024 M SmithLeave a comment

A code example for how to write BigQuery SQL to export a table to Google Cloud Storage in csv and parquet file formats. Parquet CSV

Read More ›
Data Analysis

Execute queries in BigQuery in parallel using python

10th August 202410th August 2024 M SmithLeave a comment

An example of how to run multiple queries in parallel.

Read More ›
Data Analysis

Copying BigQuery tables to a new dataset with bq command line tool

28th July 202428th July 2024 M SmithLeave a comment

With the bq command line tool moving multiple tables at a time from one BigQuery dataset to another can be done with a few lines of code. The tool can …

Read More ›
Data Analysis

From email to data warehouse – Google Edition

4th July 20246th July 2024 M SmithLeave a comment

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 …

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

Last modified BigQuery table datetime

24th February 202414th August 2024 M SmithLeave a comment
Read More ›
Data Analysis

How to host a Streamlit app on Google Cloud Run

26th August 202316th September 2023 M SmithLeave a comment

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 …

Read More ›

Posts pagination

1 2 3

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.