Re:We give every user SQL access to a shared ClickHouse cluster
by mattaitken on Saturday March 21, 2026 @10:00AM
(#47467105)
In a system with organizations, projects and advanced user access permissions having separate databases doesn’t full solve the problem. You still need access control inside each tenanted database. It also makes cross-cutting queries impossible which means users can’t query across all their orgs for example.
The DSL approach has other advantages too: like rewriting queries to not expose underlying tables, doing automatic performance optimizations…
The DSL approach has other advantages too: like rewriting queries to not expose underlying tables, doing automatic performance optimizations…