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

Apache Druid version 0.11.0 is required for full Druid compatability. Versions prior have limited functionality.

Limitations

Apache Druid has the following feature limitations:

Configuring Your Apache Druid Cluster

<DRUID_BASE_DIR> refers to the base directory in which the Apache Druid cluster is installed on a server.

Enable SQL

To enable SQL on your Druid database, add this line to the broker/runtime.properties configuration file:

<DRUID_BASE_DIR>/conf/druid/broker/runtime.properties

druid.sql.enable=true

Turn Off COUNT DISTINCT Approximation

By default, Druid approximates COUNT DISTINCT. For precise results, add this line to the broker/runtime.properties configuration file:

<DRUID_BASE_DIR>/conf/druid/broker/runtime.properties

druid.sql.planner.useApproximateCountDistinct=false

Configuring a Connection

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

Fill in the fields as follows:

If your Looker instance is Looker-hosted, contact your Looker analyst for assistance. If your Looker instance is customer-hosted, you will need command line access to install this file onto your Looker host.

  1. Click Test These Settings to verify a connection.

    Looker runs a SELECT 1 query to verify a basic connection and perform a query test. It does not validate that the catalog and schema combination exist or that the user has the required access to that schema.

    If you have any issues, check out our Testing Connections documentation.

  2. Click Add Connection to save these settings.

  3. Test the connection in SQL Runner. Navigate to SQL Runner, select your connection and schema, then check if you can see your database tables.

Feature Support

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

In the current Looker release, Apache Druid supports the following Looker features:

Next Steps

After completing the database connection, configure authentication options.

Top