TLDR Dev · ARTICLES & TUTORIALS

HOW WE GIVE EVERY USER SQL ACCESS TO A SHARED CLICKHOUSE CLUSTER

trigger.dev18 min read

Summary from the TLDR Dev newsletter

TRQL (Trigger Query Language) is a SQL-style domain-specific language that provides users with secure SQL access to a shared multi-tenant ClickHouse cluster. TRQL queries are parsed into an Abstract Syntax Tree, which undergoes schema validation, automatic tenant isolation, and time restrictions before being compiled into ClickHouse SQL.