July 2021 Summaries

The blog post emphasizes the integration of Looker and Druid to enhance data visualization experiences by leveraging Looker's modeling and ad-hoc analytics with Druid's high-performance capabilities. It provides a detailed guide on connecting Looker to Druid to create fast and interactive operational analytics experiences, emphasizing that Druid does not require caching to maintain performance, particularly with time series data. The post describes the process of accessing Rill's public Druid cluster and setting up a secure connection to Looker, allowing users to explore and visualize datasets effectively. It highlights the benefits of Looker's "Explore" architecture, which complements Druid's fast query performance, enabling users to generate real-time insights without worrying about high costs, as Rill charges based on data loaded rather than the number of queries. The guide positions the integration as a solution for achieving quick and intuitive dashboards, encouraging users interested in real-time analytics to explore further tutorials and features offered by Rill.

Rill emphasizes the importance of data interoperability and flexibility with visualization tools, providing a guide on integrating the performance of Druid, a real-time analytics database, with the interactivity of Tableau to create sub-second dashboards for operational analytics. Druid excels at executing fast OLAP queries on time-series data, and when connected with industry-standard analytics tools like Tableau, it offers a swift and interactive user experience. Rill's managed cloud service for Druid facilitates this integration, allowing users to create dashboards using public datasets available in Rill's workspace by leveraging the speed of Druid. Users can log into Rill's Cloud Console with a G-Suite account to access datasets, query them through the Apache Druid console, and connect via Tableau after setting an API password. This integration underscores Druid's capability to provide fast query access using SQL, making it compatible with various business intelligence tools, with future guides planned for other BI tool integrations.