Looker

What is Looker?

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:

Dialect Symbol	clickhouse
Dialect	ClickHouse
Looker Version	22.1
Support Level	supported
Symmetric Aggregates	No
Derived Tables	Yes
Persistent SQL Derived Tables	No
Persistent Native Derived Tables	No
Stable Views	No
Query Killing	Yes
Pivots	No
Timezones	No
SSL	Yes
Subtotals	No
JDBC Additional Params	Yes
Case Sensitive	Yes
Location Type	Yes
List Types	Yes
Percentile	Yes
Distinct Percentile	No
SQL Runner Show Processes	Yes
SQL Runner Describe Table	Yes
SQL Runner Show Indexes	No
SQL Runner Select10	Yes
SQL Runner Count	Yes
SQL Explain	No
Oauth Credentials	No
Context Comments	Yes
Connection Pooling	No
HLL Sketches	No
Aggregate Awareness	No
Incremental Pdts	No
Milliseconds	No
Microseconds	No
Materialized Views	No
Approximate Count Distinct	No

More info here.

Credentials and Connection Details

You need the following information to connect Looker

user	improvado_CustomerID_db
port	443
host	db-access.improvado.io
SSL	true
database	improvado_CustomerID_{db_id}

Replace CustomerID with the ID that you can find on the Visualization page.

Example: improvado_1234_{db_id}

Connection Instructions

Login into Looker.
Select Admin → Database/Connections or use the direct link.

Add a connection by clicking the Add Connection button.

Fill in the connection settings:

Parameter	Value	Comments
Name		The name you use to refer to this connection in models
Dialect	Clickhouse
SSH Server	No SSH server
Remote Host	db-access.improvado.io
Port	443
Database	im_1234
Username	improvado_1234_db
Password		You can change the password
Additional Params		Additional JDBC connection string parameters (advanced)
PDT And Datagroup Maintenance Schedule	/5***	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