Task 1. Query a public dataset

Load the USA Names dataset

[Big Query] > [ADD DATA] > [Public Datasets]

Query the USA Names dataset

[query editor]

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

Task 2. Create a custom table

Task 3. Create a dataset

Task 4. Load the data into a new table

Task 5. Query the table

[Compose new query]

SELECT
 name, count
FROM
 `babynames.names_2014`
WHERE
 gender = 'M'
ORDER BY count DESC LIMIT 5

reference links

• 데이터 웨어하우스 운영자를 위한 BigQuery
• bq 명령줄 도구 사용
• BigQuery API 클라이언트 라이브러리
• BigQuery API
• https://www.ssa.gov/OACT/babynames/background.html
• 데이터 세트 위치