Domo - Upload File as Dataset from Shipyard

Overview

Create a Domo dataset by uploading a csv to Domo. If the Domo Dataset Name already exists in Domo (and there are not multiple datasets with the same name), the CSV file will replace the existing dataset; otherwise a new one will be created. This will create a static dataset that can be updated by reusing this blueprint.

Variables

Name	Reference	Type	Required	Default	Options	Description
Client ID	DOMO_CLIENT_ID	Password	✅	-	-	Client ID is generated in the Domo Developer Portal. The ID should have the following scope: data, workflow, user, account, dashboard
Secret Key	DOMO_SECRET_KEY	Password	✅	-	-	The secret attached to the generated Client ID
Shipyard Folder Name	DOMO_FOLDER_NAME	Alphanumeric	➖	-	-	The Shipyard folder name where the file is contained
Shipyard File to Load	DOMO_FILE	Alphanumeric	✅	-	-	The name of the csv file that you would like to load into Domo
Domo Dataset Name	DOMO_DATASET_NAME	Alphanumeric	✅	-	-	The name of that the dataset will be given in Domo
Domo Dataset Description	DOMO_DATASET_DESCRIPTION	Alphanumeric	➖	-	-	Optional description of the dataset
Schema in Domo	DOMO_SCHEMA	Alphanumeric	➖	-	-	The Domo data types of the dataset that is to be loaded. This is an optional argument, and is only recommended if the number of columns and types is known beforehand. If left blank, the data types will be inferred by sampling the entire dataset.
Insert Method	DOMO_INSERT_METHOD	Select	✅	REPLACE	Replace: REPLACE Append: APPEND	The option to replace the entire data set with new data, or add to the existing rows
Dataset Id	DOMO_DATASET_ID	Alphanumeric	➖	-	-	The ID associated with the desired dataset. This is only necessary if modifying an existing dataset, not creating a new one.
File Name Match Type	FILE_NAME_MATCH_TYPE	Select	✅	exact_match	Exact Match: exact_match Regex Match: regex_match	None

YAML

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

source:
  blueprint: Domo - Upload File as Dataset from Shipyard
  inputs:
    DOMO_CLIENT_ID: null  ## REQUIRED
    DOMO_SECRET_KEY: null ## REQUIRED
    DOMO_FOLDER_NAME: null
    DOMO_FILE: null ## REQUIRED
    DOMO_DATASET_NAME: null ## REQUIRED
    DOMO_DATASET_DESCRIPTION: null
    DOMO_SCHEMA: null
    DOMO_INSERT_METHOD: REPLACE ## REQUIRED
    DOMO_DATASET_ID: null
    FILE_NAME_MATCH_TYPE: exact_match ## REQUIRED
  type: BLUEPRINT
guardrails:
  retry_count: 1
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - '101'
    - '107'
    - '108'
    - '109'
    - '114'
    - '115'
    - '116'