Question: Is it possible to set a separate database for local tables using `distributed_table` materialisation?

[bun4uk]

[emirkmo]

You mean

database_local/shard.table database_distributed.table

correct?

This is also how we use them allow easier role based access. Would be great.

IIRC, should not be hard to add to the first distributed table PR but I have not kept up with the changes and tests.

To generalize, we should add support for table name prefix, suffix, or separate database (same name) for the local and/or distributed tables.

[bun4uk]

Emir, hi! Yes, you understood me correct

[steffen030]

Hey, I have created a PR that allows to add a prefix to the database of the local table. By that you can filter them and apply dedicated permissions.