Domo - Upload File as Dataset from Workflows

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	✅	None	-	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	✅	None	-	The secret attached to the generated Client ID
Workflows Folder Name	DOMO_FOLDER_NAME	Alphanumeric	➖	None	-	The Workflows folder name where the file is contained
Workflows File to Load	DOMO_FILE	Alphanumeric	✅	None	-	The name of the csv file that you would like to load into Domo
Domo Dataset Name	DOMO_DATASET_NAME	Alphanumeric	✅	None	-	The name of that the dataset will be given in Domo
Domo Dataset Description	DOMO_DATASET_DESCRIPTION	Alphanumeric	➖	None	-	Optional description of the dataset
Schema in Domo	DOMO_SCHEMA	Alphanumeric	➖	None	-	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	➖	None	-	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

YAML

Below is the YAML template

YAML


source:
  template: Domo - Upload File as Dataset from Workflows
  inputs:
    DOMO_CLIENT_ID:
    DOMO_SECRET_KEY:
    DOMO_FOLDER_NAME:
    DOMO_FILE:
    DOMO_DATASET_NAME:
    DOMO_DATASET_DESCRIPTION:
    DOMO_SCHEMA:
    DOMO_INSERT_METHOD: REPLACE
    DOMO_DATASET_ID:
    FILE_NAME_MATCH_TYPE: exact_match
  type: TEMPLATE
guardrails:
  retry_count: 1
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - 101
    - 107
    - 108
    - 109
    - 114
    - 115
    - 116