sqlmesh icon indicating copy to clipboard operation
sqlmesh copied to clipboard

Add ability to specify ducklake options to ducklake config

Open seandavi opened this issue 5 months ago • 2 comments

Apologies if I missed it in the docs. But there are a few ducklake-specific configuration options that would be nice to add to the sqlmesh ducklake config. An alternative is to document how to run a duckdb SQL script in the duckdb instance that is attaching the ducklake (after ducklake is installed and attached).

seandavi avatar Aug 07 '25 19:08 seandavi

It would be great if some of the other ducklake-specific connectivity parameters could be specified as well, such as METADATA_SCHEMA.

One thing that sqlmesh appears to do when it tries to connect to a new ducklake in postgres for instance is that it silently defaults to a schema of public, when the ducklake extension defaults to a schema of main, and there are several howto's floating about that define a schema of ducklake. It might reduce confusion for new users who query the schema that they used to create their ducklake instance, but do not see what they expect.

ckarnes avatar Sep 01 '25 06:09 ckarnes

Please review and accept this PR to add support for METADATA_SCHEMA: https://github.com/TobikoData/sqlmesh/pull/5456

justbry avatar Sep 29 '25 23:09 justbry