User Guide Getting Started Help Center Documentation Community Training
Looker
  
English
Français
Deutsch
日本語
ClickHouse

Looker supports ClickHouse version 0.2 and higher.

Encrypting Network Traffic

Looker strongly recommends encrypting network traffic between the Looker application and your database. Consider one of the options described on the Enabling Secure Database Access documentation page.

To enable SSL encryption on the server side, see the ClickHouse documentation.

Users and Security

First, configure your Looker user on the ClickHouse server. ClickHouse database users are not created with the traditional CREATE USER command. Follow the ClickHouse Access Rights document to configure the users section in the users.xml file. Here is a basic example:

<!-- Users and ACL. -->
<users>
    <looker>
        <password>CHANGEIT</password>
        <networks incl="networks" />
        <profile>default</profile>
        <quota>default</quota>
    </looker>

    <web>
        <password></password>
        <networks incl="networks" />
        <profile>web</profile>
        <quota>default</quota>
        <allow_databases>
           <database>test</database>
        </allow_databases>
        <allow_dictionaries>
           <dictionary>test</dictionary>
        </allow_dictionaries>
    </web>
</users>

Also within this file, configure the appropriate database access:

<allow_databases>
    <database>database_1</database>
    <database>database_2</database>
    <database>database_3</database>
</allow_databases>

Adding the Connection

In the Admin section of Looker, navigate to the Connections page, and click New Connection.

Fill out the page as follows:

Feature Support

Looker’s ability to provide some features depends on whether the database dialect can support them.

In the current Looker release, ClickHouse supports the following Looker features:

Next Steps

After completing the database configuration, you can connect to the database from Looker using these directions.

Top