Query Looker API

White Label Data can query the Looker API using the pipeline. Looker queries using the Looker API are not written in SQL. Therefore, there is no <query> tag required to query the Looker API. First, you must Create a Looker API Connection. Next, you add a step to the pipeline with specific Looker API attributes as follows:

{
    "steps" : [
        {
            "action" : "looker_query",
            "model": "mylooker_model",
            "view" : "mylooker_view",
            "fields" : ["mylookerview.mylooker_metric"],
            "filters": {
                "mylookerview.mylooker_dimension1": "dimension_value"
            },
            "allowed_filters" : [
                {
                    "attribute_name": "myfilter",
                    "looker_filter_name" : "mylookerview.mylooker_dimension2"
                }
            ]
        }
    ]
}
Option Example Description
action looker_query Indicates that the step is a Looker API query.
model mylooker_model The name of the Looker model to query.
view mylooker_view The name of the Looker view to query.
fields ["field1", "field2"] A list of fields, either dimensions or metrics, to return with the query results.
filters See above A dictionary of name-value pairs to use as hard-coded filters on the query
allowed_filters See above A list of filters that are allowed to be passed on to the query. Filters can be either page filters or user attributes from Auth0. By requiring that you specify the allowed filters, only those that are indicated for the query will be used. Looker will return an error if other filters are sent with the query.

attribute_name is the name of the page filter or user attribute in White Label Data.

looker_filter_name is the name of the filter in Looker.
output_dataframe A string The name to use when creating a new DataFrame. This allows you to have multiple DataFrames in the pipeline context and to map columns from multiple queries to a single visualization. If no name is specified, the DataFrame will be named after the query name.
connection A string Optional. The name of the connection specified in appconfig.json. This is only needed if there are two connections of the same type. For example, if you have two Looker API connections, you need to specify which one to use for this Looker API query pipeline step.
shared true or false Indicates whether the query is shared and available to multiple visualizations. See Shared Queries.