-
Star Schema and Snowflake Schema? Why is it not a thing in DOMO?
It's a very common and even a recommended practice to do data warehousing design when you're analyzing/visualizing data but why is it not a thing in DOMO? It seems like you have to create 1 whole big and gigantic FACT Table every time you want to analyze something when you're working with an enterprise data level. And what…
-
Beast Mode Description
Similar to how you can describe individual columns in a dataset (via the dataset schema view), a useful new feature could be the ability to describe beast modes. Currently, our practice has been to add a comment inside of the beast mode expression explaining what it's used for, but this comment cannot be referenced in…
-
Magic ETL: Avoid loading all the input columns and rows from data vault.
In Magic ETL, to avoid loading all the input columns and rows from the data vault. On the Input tile, under “Data Handling Section” if there could be a provision (refer to attached pdf with screenshot) check box to select required columns (simple request) and text box to add a where clause on each column Or one text box to…
-
Give Schema Management Toolkit the ability to set a default value when adding a new column
When you add a new column — via Schema Management in the toolkit — to a dataset that is either partitioned or updated by appending, it would be nice to be able to set a default value for the column so you don't have to go through contortions to update the older records.
-
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…