Josh Wills

Results 174 comments of Josh Wills

Ah gotcha— yeah, the list of tables in the source is a key part of the config. An example for the README would be most welcome!

Ah so a couple of ways: one way is to create some sort of python environment for the dbt run-- Docker container, virtualenv, whatever floats your boat-- install your package...

Which version of the project? And you did the import like `import example`?

I should have said— I have an example of a project that used the module paths here: https://github.com/jwills/jaffle_shop_duckdb

Mmm return from what? The return type of the model function needs to be something DuckDB can turn into a table— but for your own utility functions you should be...

A PR would be most welcome— thank you!

@jesseginsberg this might seem stupid, but does it work if you do the options as the (lowercase) `partition_by` instead of the uppercase `PARTITION_BY`? The logic we use for constructing the...

IIRC you can specify any set of key-value pairs that you like in the `options` dict and we will copy them over to the clause we append to the `COPY...

Any boolean options (like `overwrite_or_ignore`) will need a dummy true value too-- like `1`-- to work correctly. You can see the "logic" we employ for this here: https://github.com/duckdb/dbt-duckdb/blob/master/dbt/adapters/duckdb/impl.py#L108

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](https://github.com/jwills/duckdbt/blob/main/duckdbt/server.py) (which...