Devcontainer support including Duckdb bootstrapped with minimal synthetic data

vvcb commented 2 months ago

As discussed at the dbt sync community call on 2024-09-20, this PR adds devcontainer support to the project.

Key features:

Python 3.12 with minimal requirements pre-installed for dbt to work with DuckDb.
Key VS Code extensions to support development including dbt-power-user extension (user may need to set preferred Python environment to ./dbt-env/bin/python3 to allow the extension to work - this requires a longer-term fix where the extension recognises this automatically.
dbt dependencies and pre-commit are installed at container creation time
DuckDb database created in ./data/ with minimal synthetic data loaded from seed files.

The user will have to run dbt run to create the rest of the models.

vvcb commented 2 months ago

@lawrenceadams , thank you for reviewing this. Agree with most things - but this was to get the devcontainer working with the existing codebase in preparation for the OHDSI symposium software demo to allow users to spin this up in their own GitHub codespaces.

Disagree with a few. Very happy for any of this to be modified as long as it works for everyone.

lawrenceadams commented 2 months ago

In all honesty is good to go for all intents and purposes, a lot of these issues are a reflection of python being annoying to manage packages with IMHO!

katy-sadowski commented 1 month ago

@vvcb thanks for working on this - i left a couple comments. also needs a rebase to incorporate recent changes 😄

i had been waiting for Heidi to take a look since Codespaces was her idea ... will ping in Teams to make sure she saw this.

OHDSI / dbt-synthea

Devcontainer support including Duckdb bootstrapped with minimal synthetic data #57