search

OHDSI / dbt-synthea

[Under development] A dbt ETL project to convert a Synthea synthetic data set into the OMOP CDM
https://ohdsi.github.io/dbt-synthea/
Apache License 2.0
16 stars 6 forks source link

Clarified about where to create `.dbt` Folder #89

Open TheCedarPrince opened 4 weeks ago

TheCedarPrince commented 4 weeks ago

Added some notes about where to create the .dbt folder. Didn't know the proper solution for Windows off the top of my noggin however. Also, does the .dbt folder have to live at root?

katy-sadowski commented 4 weeks ago

Regarding location of .dbt, it does not have to be at root. Maybe we could link out to this page for more info? https://docs.getdbt.com/docs/core/connect-data-platform/connection-profiles

lawrenceadams commented 4 weeks ago

Regarding location of .dbt, it does not have to be at root. Maybe we could link out to this page for more info? https://docs.getdbt.com/docs/core/connect-data-platform/connection-profiles

I agree, I tend to leave the profiles.yml file in the root of the working directory - especially when using duckdb and not having a risk of leaking credentials -rather than at my $HOME/.dbt, and the docs hint to this

dbt will search the current working directory for the profiles.yml file and will default to the ~/.dbt/ directory if not found.

In fairness, this is unclear for a complete newcomer to dbt/dbt-synthea so I think is a good thing to add in.

@TheCedarPrince maybe it's worth modifying to say it can be in the root of the working directory, rather than in $HOME/.dbt? I'd argue the former is more straightforward

TheCedarPrince commented 4 weeks ago

Sure! I'll tweak the PR later today -- but what is the command to jump to root on Windows? dir ... somthing ?

lawrenceadams commented 4 weeks ago

Good question - I think it is cd %HOMEPATH% - but refuse to do any development work on Windows without using WSL so I have not tested! 😆

TheCedarPrince commented 3 weeks ago

@lawrenceadams and @katy-sadowski , fixed up the language here.