Transfer · From Tasks · from_looker

Purpose

Imports data from Looker.

Authentication

Before you can download data from Looker you have to get an API3 key. Ask the Looker administrator of your organization.

Extract types

Below are the types of extract for Looker. Click on an extract type for an explanation.

type: query

Load data with a Looker query, that uses the LookML framework.

Example usage

extract:
    type: query
    conn_id: looker
    model: demo
    view: hits
    fields:
        - hits.sessions
        - hits.tstamp_date
    filters:
        hits.tstamp_time: 7 days ago for 7 days
    limit: 500
    total: no
    row_total: no
    query_timezone: Europe/Amsterdam

Properties

propertytyperequireddescription
typeenumerator(query)yesSet type to query
conn_idstringnoDefault is looker.
modelstringyesName of the model.
viewstringyesName of the view.
fieldsarray of stringsyesList of field names. Can be dimensions and measures.
filtersobjectnoFilters. Construct like hits.tstamp_time: 7 days ago for 7 days
limitintnoLimit on the resultset.
totalyesno (boolean)noDefault is no. Add the totals to the resultset.
row_totalyesno (boolean)noDefault is no. Add the row totals to the resultset.
query_timezoneenumerator (timezone)noAdd the timezone, e.g. Europe/Amsterdam

type: look

Load data from a Looker Look.

Example usage

extract:
    conn_id: looker
    type: look
    look_id: 999

Properties

propertytyperequireddescription
conn_idstringnoDefault is looker.
typeenumerator(look)yesSet type to look
look_idintnoUnique ID of the Look.

type: sql_runner

Load data from SQL Runner in Looker.

Example usage

extract:
    conn_id: looker
    type: look
    look_id: 999

Properties

propertytyperequireddescription
conn_idstringnoDefault is looker.
typeenumerator(sql_runner)yesSet type to sql_runner
connection_namestringnoName of the connection.
querystringyesUse either query or template (below). Query to be executed, whose results will be uploaded to the destination.
templatestringyesUse either query(above) or template. Contains a link to a file in the `includes` folder in your repository that contains the SQL statement. This query will be executed and the results will be uploaded to the destination.
paramsobjectnoParameters that can be set. Useful for templating.

type: all_dashboards

Import all dashboard names to a table.

Example usage

extract:
    conn_id: looker
    type: all_dashboards

Properties

propertytyperequireddescription
conn_idstringnoDefault is looker.
typeenumerator(all_dashboards)yesSet type to all_dashboards

Details

itemdescription
APILooker API