Configuring duckdb settings / Persisting SET

[zbyte64]

I have a pattern where I use duckdb as a data catalogue that wraps http based resources as a view and caches the http payloads. Downstream sqlmesh models select from that view into materialized tables. Works great but the views require a setting in duckdb to be set which I add as a pre statement: SET allow_asterisks_in_http_paths = true;. Problem is that if I apply a plan after those duckdb views are made then the setting is never applied and then sqlmesh attempts to query the view and it fails.

I am thinking what I might need is a way to specify SET statements at the beginning of my duckdb session. I dont see this as an option with DuckDBConnectionConfig

[zbyte64]

I must be blind, it's connector_config