Skip to main content

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​

NameReferenceTypeRequiredDefaultOptionsDescription
Client IDDOMO_CLIENT_IDPasswordβœ…--Client ID is generated in the Domo Developer Portal. The ID should have the following scope: data, workflow, user, account, dashboard
Secret KeyDOMO_SECRET_KEYPasswordβœ…--The secret attached to the generated Client ID
Shipyard Folder NameDOMO_FOLDER_NAMEAlphanumericβž–--The Shipyard folder name where the file is contained
Shipyard File to LoadDOMO_FILEAlphanumericβœ…--The name of the csv file that you would like to load into Domo
Domo Dataset NameDOMO_DATASET_NAMEAlphanumericβœ…--The name of that the dataset will be given in Domo
Domo Dataset DescriptionDOMO_DATASET_DESCRIPTIONAlphanumericβž–--Optional description of the dataset
Schema in DomoDOMO_SCHEMAAlphanumericβž–--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 MethodDOMO_INSERT_METHODSelectβœ…REPLACEReplace: REPLACE

Append: APPEND

The option to replace the entire data set with new data, or add to the existing rows
Dataset IdDOMO_DATASET_IDAlphanumericβž–--The ID associated with the desired dataset. This is only necessary if modifying an existing dataset, not creating a new one.
File Name Match TypeFILE_NAME_MATCH_TYPESelectβœ…exact_matchExact Match: exact_match

Regex Match: regex_match

Type of search pattern matching you wish to use

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:
- '200'
- '201'
- '203'
- '204'
- '205'
- '210'
- '211'
- '214'
- '215'
- '216'