Loading data
If you would like to load toy_shop data to some of your testing DBs, clone our repo: https://github.com/re-data/re-data And copy our template of dbt project for this tutorial:
git clone https://github.com/re-data/re-datacd re-datacp -r getting_started/toy_shop/ my_toy_shop_tutorial
And specify connection to db you would like to use, example postgres connection here:
~/.dbt/profiles.yml
toy_shop: target: dev outputs: dev: type: postgres host: xxx user: xxx password: xxx port: 5432 dbname: xxx schema: toy_shop threads: 4
Make sure you can use schema: toy_shop in your DB.
Now you are ready to load load data, you can do it with running:
dbt seed