MarquinSmith - Part 7

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 …

Personal Development

Physical Health Tracker – April 2024

12th May 202412th May 2024 M SmithLeave a comment

Personal Development

Physical Health Tracker – March 2024

12th May 202412th May 2024 M SmithLeave a comment

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 …

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 …

Personal Development