sql | MarquinSmith

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 …

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

Last modified BigQuery table datetime

24th February 202414th August 2024 M SmithLeave a comment

Data Analysis

SQL Query for exits on Adobe Analytics click stream data

29th January 202429th January 2024 M SmithLeave a comment

Web Analytics

SQL Query for entries on Adobe Analytics click stream data

25th January 202425th January 2024 M SmithLeave a comment

Web Analytics

SQL Query for orders on Adobe Analytics click stream data

24th January 202425th January 2024 M SmithLeave a comment

Web Analytics

SQL Query for unique visitors on Adobe Analytics click stream data

24th January 202424th January 2024 M SmithLeave a comment

Web Analytics

SQL Query for visits on Adobe Analytics click stream data

24th January 202424th January 2024 M SmithLeave a comment

Web Analytics

SQL Query for page views on Adobe Analytics click stream data

24th January 202424th January 2024 M SmithLeave a comment

Data Analysis

UNNESTing in BigQuery – a guided introduction

5th October 20235th October 2023 M SmithLeave a comment

The UNNEST function in BigQuery is used to transform arrays or repeated fields within a table into individual rows. This is particularly useful when dealing with data stored in nested …