Looker - Download SQL Query as File to Shipyard

Overview

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

Variables

Name	Reference	Type	Required	Default	Options	Description
Looker URL	LOOKER_URL	Alphanumeric	✅	-	-	The base URL of your organization's looker instance. Include https://
Looker Client ID	LOOKER_CLIENT_ID	Password	✅	-	-	The Client ID generated from Looker for API access
Looker Client Secret	LOOKER_CLIENT_SECRET	Password	✅	-	-	The secret key generated from Looker for API access
Looker Slug	LOOKER_SLUG	Alphanumeric	➖	-	-	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 Type	LOOKER_FILE_TYPE	Select	✅	csv	JSON (.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 Name	LOOKER_DESTINATION_FOLDER_NAME	Alphanumeric	➖	-	-	Folder where the file will be created. Leave blank to store in the current working directory
File Name	LOOKER_DESTINATION_FILE_NAME	Alphanumeric	✅	-	-	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'