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
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