rill icon indicating copy to clipboard operation
rill copied to clipboard
verified publisher icon rilldata

Clickhouse: Rill should work in a different and possibly unique database when building models

Open k-anshul opened this issue 1 year ago • 2 comments

Add an option database in connector config that allows setting the database to be used for creating models.

k-anshul avatar Aug 19 '24 12:08 k-anshul

This will also allow us to fix this issue for self hosted replicated database deployments : https://github.com/rilldata/rill/issues/5420 We can check if the database is a replicated database and if yes we can create tables in replicated mode by default. This avoid taking cluster name as input from the user.

k-anshul avatar Aug 19 '24 12:08 k-anshul

What if a database is specified in the DSN? Also, are you proposing this defaults to something like rill or should use the default database if not specified?

If it doesn't use the default database by default, then models or dashboards that reference pre-existing tables won't work without specifying the default database explicitly, right? That's probably fine, but something we should document – it would also be a breaking change, how should we handle that for current ClickHouse projects?

begelundmuller avatar Aug 19 '24 13:08 begelundmuller