Imports data from Looker.
Before you can download data from Looker you have to get an API3 key. Ask the Looker administrator of your organization.
Below are the types of extract for Looker. Click on an extract type for an explanation.
Load data with a Looker query, that uses the LookML framework.
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
| property | type | required | description |
|---|---|---|---|
type | enumerator(query) | yes | Set type to query |
conn_id | string | no | Default is looker. |
model | string | yes | Name of the model. |
view | string | yes | Name of the view. |
fields | array of strings | yes | List of field names. Can be dimensions and measures. |
filters | object | no | Filters. Construct like hits.tstamp_time: 7 days ago for 7 days |
limit | int | no | Limit on the resultset. |
total | yesno (boolean) | no | Default is no. Add the totals to the resultset. |
row_total | yesno (boolean) | no | Default is no. Add the row totals to the resultset. |
query_timezone | enumerator (timezone) | no | Add the timezone, e.g. Europe/Amsterdam
|
Load data from a Looker Look.
extract:
conn_id: looker
type: look
look_id: 999
| property | type | required | description |
|---|---|---|---|
conn_id | string | no | Default is looker. |
type | enumerator(look) | yes | Set type to look |
look_id | int | no | Unique ID of the Look. |
Load data from SQL Runner in Looker.
extract:
conn_id: looker
type: look
look_id: 999
| property | type | required | description |
|---|---|---|---|
conn_id | string | no | Default is looker. |
type | enumerator(sql_runner) | yes | Set type to sql_runner |
connection_name | string | no | Name of the connection. |
query | string | yes | Use either query or template (below). Query to be executed, whose results will be uploaded to the destination. |
template | string | yes | Use 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. |
params | object | no | Parameters that can be set. Useful for templating. |
Import all dashboard names to a table.
extract:
conn_id: looker
type: all_dashboards
| property | type | required | description |
|---|---|---|---|
conn_id | string | no | Default is looker. |
type | enumerator(all_dashboards) | yes | Set type to all_dashboards |
| item | description |
|---|---|
API | Looker API |