Query the underlying ClickHouse ® database in Tinybird via HTTP

Tinybird has introduced support for querying the ClickHouse database using its native HTTP interface, enhancing connectivity with BI tools, SQL clients, and ORMs without needing additional plugins. This development replaces the deprecated Postgres-based BI connector, offering a more efficient integration method and providing direct access to data with the same performance and security guarantees as the existing API endpoints. As ClickHouse has gained popularity, the new interface allows users to connect directly to Tinybird, making it easier to build observability dashboards, explore data, and connect BI tools like Grafana, Superset, and Metabase. The interface, built on Tinybird's /v0/sql endpoint, supports system tables for metadata introspection, provides real-time observability over queries, and allows reuse of Tinybird pipes in BI tools. While it currently supports only read-only queries, further enhancements such as advanced system table support and self-hosted infrastructure are anticipated, simplifying integration and offering more flexibility in data querying and visualization.