Coding Challenge: Querying a Public Dataset

Problem

Some datasets are available publicly on BigQuery, which are very useful for practice! In this exercise, we’ll use the NYC Citi Bike Trips dataset.

Use the link and click the “VIEW DATA SET” button. You should now see the project bigquery-public-data and the dataset new_york_citibike.

Update the public_data.yml source and the daily_trips.sql model so that daily_trips contains the date and the number of trips for that date.

Playground

Add your solution code in the widget below.