-
Notifications
You must be signed in to change notification settings - Fork 1
Scaffolding a dbt project from an existing dbt profile
winnie edited this page Apr 20, 2024
·
1 revision
- 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. - Navigate to the directory you keep dbt project in (for me this is
~/dev
), or wherever you want to generate the output directory. - Run
tbd
. - Select 'Yes' for using a dbt profile to connect with.
- Select 'Yes' for scaffolding a dbt project.
- Choose your prefix or just hit enter to stick with 'stg'.
- Give your new project a name.
- Select the profile you want to generate models for from the list.
- Select the
output
from that profile you want to use (these are typically things likeprod
,dev
,staging
etc). - Choose a schema that the profile you selected has access to read from.
- 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.
- Choose 'No' for the LLM features.
- Enter an output directory name (it needs to either not exist yet or be empty) or just hit enter to stick with 'build'.
- Done!