Skip to content

Scaffolding a dbt project from an existing dbt profile

winnie edited this page Apr 20, 2024 · 1 revision
  1. Ensure that you have the profile you want configured either in ~/.dbt/profiles.yml or the root of the directory you're going to run tbd in.
  2. Navigate to the directory you keep dbt project in (for me this is ~/dev), or wherever you want to generate the output directory.
  3. Run tbd.
  4. Select 'Yes' for using a dbt profile to connect with.
  5. Select 'Yes' for scaffolding a dbt project.
  6. Choose your prefix or just hit enter to stick with 'stg'.
  7. Give your new project a name.
  8. Select the profile you want to generate models for from the list.
  9. Select the output from that profile you want to use (these are typically things like prod, dev, staging etc).
  10. Choose a schema that the profile you selected has access to read from.
  11. Enter the database that schema is in. The schema and the database can be different than the ones specificed in the profile by default, as long as the profile has access to run queries against them.
  12. Choose 'No' for the LLM features.
  13. Enter an output directory name (it needs to either not exist yet or be empty) or just hit enter to stick with 'build'.
  14. Done!