Skip to main content

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