Josh Wills
Josh Wills
Nah, more like laziness and poor documentation on my part. ;-)
Ah, there isn't one right now, but I would be happy to help add one if I can-- is there somewhere I can read up on what is needed to...
Ah you mean like beyond what can be done with the built-in “settings” construct? You can use dbt-duckdb plugins to do any kind of customization of the DuckDB connection that...
Docs are here: https://github.com/jwills/dbt-duckdb#configuring-dbt-duckdb-plugins
The `log_query_path` is a setting, so you can specify it like: ``` SET log_query_path = '/tmp/duckdb_log/'; ``` ...which you can express in a dbt profile config like this: ``` default:...
For the time being, assuming your use case and materialization strategy supports it, I recommend using hooks to drop/add indexes from any models in DuckDB that need them.
Ah, that's a good (and important!) question that I don't know the answer to; let me ask about it in the Meltano Slack!
There's also an argument to be made that I should ditch Meltano and create my own DuckDB-centric MDS in a box project where I design all of the bits to...
Jacob's recommendation is to use `target-parquet` instead of `target-duckdb` to get around the issue, and I am thinking that is the best short-term strategy here until I actually build that...
Ah, interesting-- thank you so much Amir!