4.2.1 - Set Up Project

Last updated Feb 18, 2025

Estimated time spent on this lesson | ~35 min

Copy NYC Taxi data into your BigQuery
- One option is this python script to get the data into your bucket:

I do not recommend these linked below because for the HW the data is different...;

Open a free developer dbt cloud account following
Following these instructions to connect to your BigQuery instance in dbt
1. More detailed instructions in
2. I recommend creating a dataset in BigQuery for your dbt model info, that way you can set-up the correct geographical location there! Otherwise, there may be a US vs. EU mismatch. Then when you connect to BigQuery in dbt, just use the dataset name you already created.
Follow the below link to connect to Github - you can use SSH found above in 3a

Last updated 3 months ago