Looker BI is a business intelligence and data pipelines visualization tool that is one hundred percent in-database, capitalizing on the fastest and most recent analytic databases for real-time results. Users can easily customize and create an array of interactive visualization from the assortment of charts and graphs the platform provides.
Pros:
Great customer support
Easy to use
Integrates with databases and big data platforms
Feature support
For Looker to support some features, your database dialect must also support them.
In Looker 22.2, ClickHouse supports the following Looker features:
Cron string specifying schedule for checking triggers and dropping expired tables. Interpreted in application timezone, currently ‘America/Los_Angeles’
SSL
Checked
Verify SSL Cert
Unchecked
Max Connections Per Node
30
Max number of connections Looker will allow at one time. Must be at least 5 and no more than 100
Connection Pool Timeout
120
The number of seconds a query will wait before timing out due to a full connection pool. Must be greater than 90
SQL Runner Precache
Checked
Precache tables for faster lookup
Fetch Information Schema For SQL Writing
Unchecked
If checked, the information schema is fetched and cached when writing SQL, allowing for more SQL optimizations. Uncheck if this database has an especially slow information schema
You can test these settings now or at the next step
Find the created connection in the list of connections and make sure all settings are correct.
IMPORTANT: be sure to use tables with the _all_data suffix in your reports.