Open grahamwetzler opened 1 year ago
A workaround I found is to add LOAD postgres_scanner
to the model's pre-hook
or the project's on-run-start
Hey @grahamwetzler! I'm on vacation (I go on vacation a lot these days) but the intent is to run a BV server that is dbt-aware via the duckdbt server (which essentially configures a BV server by using the config info from the profiles.yml
file, including e.g. loading extensions and what not.)
I still need to update it for dbt-duckdb 1.6.0 and do some other things (see above re: vacation), but it's on my TODO list for when I get back!
Ah, ok. So user error? If so I will close and wait patiently for your update 😀
Nah, more like laziness and poor documentation on my part. ;-)
I'm getting this error when trying to build a model that uses
postgres_scan
in dbt-duckdb and using Buena Vista as a remote:Steps to reproduce:
Run Buena Vista with
python3 -m buenavista.examples.duckdb_postgres target/dbt.duckdb
Configure
profiles.yml
:Materialize a model that uses
postgres_scan
to connect to another Postgres server