Google Cloud Platform Looker Connection

Communication between Airflow and Looker is done via Looker API. To facilitate the API communication Looker operators use Looker SDK as an API client. Before calling API, Looker SDK needs to authenticate itself using your Looker API credentials.

The HTTP connection type provides connection to Looker API.

The LookerHook uses this connection to run API requests on a Looker instance issued by LookerStartPdtBuildOperator and LookerCheckPdtBuildSensor.

Configuring the Connection

Host (required)

Base URL for Looker API. Do not include /api/* in the URL.

Login (required)

Looker API client id.

Password (required)

Looker API client secret.

Port (optional)

Port for Looker API. If hosted on GCP, don’t specify the port leaving just the host.

Extra (optional)

Specify the extra parameters (as json dictionary) that can be used in Looker connection. The following parameters are supported:

  • verify_ssl - Set to false only if testing locally against self-signed certs. Defaults to true if not specified.

  • timeout - Timeout in seconds for HTTP requests. Defaults to 2 minutes (120) seconds if not specified.

Example “extras” field:

{
   "verify_ssl": true,
   "timeout": 120,
}

Connection URI

A URL configuration example of a Looker connection:

AIRFLOW_CONN_YOUR_CONN_ID='http://YourClientID:YourClientSecret@https%3A%2F%2Fyour.looker.com:19999?verify_ssl=true&timeout=120'

Was this entry helpful?