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
Name | Reference | Type | Required | Default | Options | Description |
---|---|---|---|---|---|---|
Looker URL | LOOKER_URL | Alphanumeric | ✅ | None | - | The base URL of your organization's looker instance. Include https:// |
Looker Client ID | LOOKER_CLIENT_ID | Password | ✅ | None | - | The Client ID generated from Looker for API access |
Looker Client Secret | LOOKER_CLIENT_SECRET | Password | ✅ | None | - | The secret key generated from Looker for API access |
Looker Connection Type | LOOKER_CONNECTION_TYPE | Select | ✅ | connection_name | Connection 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 Value | LOOKER_CONNECTION_VALUE | Alphanumeric | ➖ | None | - | 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 Query | LOOKER_SQL_QUERY | Alphanumeric | ✅ | None | - | The SQL query you would like to store |
YAML
Below is the YAML template
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