Objective

Looking for ways to refresh my SQL coding, I’ve stumbled upon a Kaggle on-line course to learn how to use Google BigQuery. It’s a nice and fun way to learn about a new tool! This led me to enroll to the Kaggle SQL summer camp: Can’t wait to learn new stuff.
In the meantime, I’ve gathered the templates for later use of bigquery commands.

Contents

Bigquery programs to run basic SQL commands based on a Kaggle tutorial.

Using GoogleCloudPlatform

You have to have the bigquery library installed from Google Cloud. Then make sure you’re authenticated on Google Cloud Platform. See https://cloud.google.com/bigquery/docs/reference/libraries#client-libraries-install-python for more info.

Source of data

Kaggle’s introduction to SQL for working with databases, using Google BigQuery to scale to massive datasets.
https://www.kaggle.com/learn/intro-to-sql