Skip to main content

Looker - Download SQL Query as File to Shipyard

Overview​

Quickly download a Look from Looker as a variety of file types.

Variables​

NameReferenceTypeRequiredDefaultOptionsDescription
Looker URLLOOKER_URLAlphanumericβœ…--The base URL of your organization's looker instance. Include https://
Looker Client IDLOOKER_CLIENT_IDPasswordβœ…--The Client ID generated from Looker for API access
Looker Client SecretLOOKER_CLIENT_SECRETPasswordβœ…--The secret key generated from Looker for API access
Looker SlugLOOKER_SLUGAlphanumericβž–--The slug value associated with the query to run. The value should be left blank if this is a downstream vessel of the Create SQL Runner Query blueprint.
File TypeLOOKER_FILE_TYPESelectβœ…csvJSON (.json): json

Text (.txt): txt

CSV (.csv): csv

JSON Detail (.json): json_detail

Markdown (.md): md

Excel (.xlsx): xlsx

SQL (.sql): sql

PNG (.png): png

JPG (.jpg): jpg

The type of file that will be generated from the SQL Query.
Folder NameLOOKER_DESTINATION_FOLDER_NAMEAlphanumericβž–--Folder where the file will be created. Leave blank to store in the current working directory
File NameLOOKER_DESTINATION_FILE_NAMEAlphanumericβœ…--File name that will be created for the Look being downloaded. Include the extension and ensure that it matches the selected File Type.

YAML​

Below is the YAML template for this Blueprint and can be used in the Fleet YAML Editor.

source:
blueprint: Looker - Download SQL Query as File to Shipyard
inputs:
LOOKER_URL: null ## REQUIRED
LOOKER_CLIENT_ID: null ## REQUIRED
LOOKER_CLIENT_SECRET: null ## REQUIRED
LOOKER_SLUG: null
LOOKER_FILE_TYPE: csv ## REQUIRED
LOOKER_DESTINATION_FOLDER_NAME: null
LOOKER_DESTINATION_FILE_NAME: null ## REQUIRED
type: BLUEPRINT
guardrails:
retry_count: 1
retry_wait: 0h0m0s
runtime_cutoff: 1h0m0s
exclude_exit_code_ranges:
- '101'
- '102'
- '103'
- '203'
- '204'
- '205'
- '206'
- '207'
- '208'
- '209'