Documentation

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

  1. Login into Looker.
  2. Select Admin → Database/Connections or use the direct link.
  1. Add a connection by clicking the Add Connection button.
  1. 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
  1. You can test these settings now or at the next step
  1. 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.

Related articles
No items found.
No items found.