Looker

Looker is a business intelligence tool that also provides a semantic layer.

About

Looker is a web based business intelligence and data management tool that provides a semantic layer to facilitate querying. It can be deployed in the cloud, on GCP, or on premises.

Requirements

Database User

This source only uses API authentication. You will need to create an API user to login to Looker.

Example

sources:
    my-looker-source:
        kind: looker
        base_url: http://looker.example.com
        client_id: ${LOOKER_CLIENT_ID}
        client_secret: ${LOOKER_CLIENT_SECRET}
        verify_ssl: true
        timeout: 600s

The Looker base url will look like “https://looker.example.com”, don’t include a trailing “/”. In some cases, especially if your Looker is deployed on-premises, you may need to add the API port number like “https://looker.example.com:19999”.

Verify ssl should almost always be “true” (all lower case) unless you are using a self-signed ssl certificate for the Looker server. Anything other than “true” will be interpreted as false.

The client id and client secret are seemingly random character sequences assigned by the looker server. If you are using Looker OAuth you don’t need these settings

Tip

Use environment variable replacement with the format ${ENV_NAME} instead of hardcoding your secrets into the configuration file.

Reference

fieldtyperequireddescription
kindstringtrueMust be “looker”.
base_urlstringtrueThe URL of your Looker server with no trailing /).
client_idstringfalseThe client id assigned by Looker.
client_secretstringfalseThe client secret assigned by Looker.
verify_sslstringfalseWhether to check the ssl certificate of the server.
timeoutstringfalseMaximum time to wait for query execution (e.g. “30s”, “2m”). By default, 120s is applied.
use_client_oauthstringfalseUse OAuth tokens instead of client_id and client_secret. (default: false)
show_hidden_modelsstringfalseShow or hide hidden models. (default: true)
show_hidden_exploresstringfalseShow or hide hidden explores. (default: true)
show_hidden_fieldsstringfalseShow or hide hidden fields. (default: true)