Setup Bigquery

A quick guide on how to setup BigQuety

Setup

Setting up BigQuery takes a few minutes. Go to your console.cloud.google.com page and add the BigQuery service to your project.

alt text

Click on create dataset and fill in the information as you wish. Once complete we can add tables and propagate it with data. If you wish to upload a CSV file you would need to eanable the BigQuery API.

You can also use one of the free public datasets by running a SQL statement and saving the result to a table.

SELECT
  name, gender,
  SUM(number) AS total
FROM
  `bigquery-public-data.usa_names.usa_1910_2013`
GROUP BY
  name, gender
ORDER BY
  total DESC
LIMIT
  10

Next

Related