February 2024 Summaries

Rill has announced a new live connector for ClickHouse, a high-performance open-source database engine, to enhance the speed and interactivity of its dashboards. This integration allows users to build exploratory dashboards directly on ClickHouse tables without data ingestion or orchestration, leveraging ClickHouse's architecture for efficient handling of massive datasets. The collaboration began after a meeting with ClickHouse's creator, Alexey Milovidov, at FOSDEM, where a proof of concept demonstrated the capability to handle 480 billion records with sub-second load times. The ClickHouse connector enables OLAP queries directly on the datastore, bypassing the need for data transfer to Rill's in-memory engine, and follows a workflow involving data management in ClickHouse, metric development in Rill Developer, and dashboard sharing via Rill Cloud. With the connector now integrated into Rill's 0.41 release, the company plans to further enhance performance and introduce data modeling capabilities, inviting the community to participate and provide feedback through their Discord channel.

Rill Developer, an open-source integrated development environment (IDE), leverages AI to expedite the creation of operational dashboards from S3 data sources by incorporating large language models (LLMs) like OpenAI's GPT series to generate SQL-based BI-as-code. The latest release emphasizes combining BI-as-code with AI for rapid dashboard creation, where SQL and YAML define the structure, and a validation phase ensures accuracy in AI-generated measures. This approach mirrors the productivity gains seen with GitHub Copilot, allowing developers to edit, visualize, and deploy dashboards efficiently. The integration with OpenAI underscores Rill's commitment to simplifying the data-to-dashboard process, offering a quick setup, and engaging user feedback via their community platforms.