Skip to main content
Skip table of contents

Looker - Create SQL Runner Query

Overview

Quickly create a SQL query (stored as a `slug`) to be run in a downstream vessel. This works best when paired with `Looker - Download SQL Query as File` blueprint.

Variables

NameReferenceTypeRequiredDefaultOptionsDescription
Looker URLLOOKER_URLAlphanumericNone-The base URL of your organization's looker instance. Include https://
Looker Client IDLOOKER_CLIENT_IDPasswordNone-The Client ID generated from Looker for API access
Looker Client SecretLOOKER_CLIENT_SECRETPasswordNone-The secret key generated from Looker for API access
Looker Connection TypeLOOKER_CONNECTION_TYPESelectconnection_nameConnection Name: connection_name

Model Name: model_name
The type of connection to form the SQL runner query. This is either by connecting to a specific connection, or a model
Looker Connection ValueLOOKER_CONNECTION_VALUEAlphanumericNone-Depending the selection in the Looker Connection Type argument, this will either be the name of the connection or the name of the model
Looker SQL QueryLOOKER_SQL_QUERYAlphanumericNone-The SQL query you would like to store

YAML

Below is the YAML template

YAML

source:
  template: Looker - Create SQL Runner Query
  inputs:
    LOOKER_URL:
    LOOKER_CLIENT_ID:
    LOOKER_CLIENT_SECRET:
    LOOKER_CONNECTION_TYPE: connection_name
    LOOKER_CONNECTION_VALUE:
    LOOKER_SQL_QUERY:
  type: TEMPLATE
guardrails:
  retry_count: 1
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - 101
    - 102
    - 103
    - 203
    - 204
    - 205
    - 206
    - 207
    - 208
    - 209

      
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.