How can I fix a workbench job where the Schema is locked and doesn't match the dataset?
Hi, everyone! I'm running into an issue with the workbench and can't seem to find a solution. One of my jobs has the work bench schema messed up and is pulling nonexistent headers. I'm not sure if it is getting this information from a previous upload but it doesn't even match the column names or number of columns. I…
How do I change the field type for a column on an existing table?
My company recently released a new version of our online platform and I am mapping its new database fields to my already existing Domo reporting tables. In the previous system we used a simple integer as the primary key for all of our tables. In the new version we have switched to UUID values for many of our tables.…
Schema not keeping changes, but no error given - have you run into this?
Hello, So I have set up a job using MySQL ODBC - executed, all good. Job T Then set up another job with a local CSV file - executed all good. Job A So then I want to update Job T to do a lookup transform of the results from Job A. This seems to run well. But I also need to update the schema. I need to remove a column and I…
How do I create a Merge Key for Azure Synapse SQL Connector?
We have a large dataset that we update daily, we want to change from the "Replace" update setting to the "Merge" setting. It asks for a "Merge Key Location" - the input field just continuously tries to load something How do we switch to the Merge update method?
Create DataSet API is not creating schema anymore.
This was working before. I am trying to create a dataset with a schema of 2 columns. The dataset creation is succesful but it is getting created without any columns in it. Even the example given in developer.domo.com doesn't work. I tried both dataset and Stream APIs. In both cases the API successfully created dataset but…
friendly naming or information in filters
Hello Domo Community We are looking for a friendlier way to present the available fields in the card filters, I understand that I can create Beast Mode of the fields but this doubles the amount of fields available to the user and would generate more doubts than it solves. Is there any way we can assign an alias in the same…
Append data when columns missing from input data
Hello. I have a master dataset in domo which was originally extracted from a legacy system, and has 'timestamp' and 'id' columns which were specific to the legacy data set. New data is identical but with the exception of the fact that it doesn't include those columns. It seems if I try to append the data to the master data…