-
Not max characters but what is the highest number allowed in a field
Hello, I know the text fields have a max of 1024 characters in a field but what about for a number and a fixed decimal? I have a value of ###,###,###,###,### that is just displaying blank in a fixed decimal field. Any input would be helpful.
-
Workbench Extremely Slow Out Of Nowhere
Hello All, One specific dataset for some reason has started to "crawl" when processing. It used to take anywhere from 5-10min to process but now it is only processing around 3k rows every 5 min. Any idea where to begin to look for a reason of this to all of a sudden happen? We have this on a 2-hour schedule so since it…
-
Limit input/output rows
Hello, I am wondering if there is a way to set a limit on an object coming in from workbench or limiting it in DOMO itself to "error" out if the resulting dataset will contain more than 10mil or to not allow more than 5 mil rows to be processed. These are just examples, I would like to know if there is anything of this…
-
Storage cost questions
Hello all, Just curious about something. When a dataset is created with lets just say 1 mil rows, but then later in the day it increases to 2 mil, and then finally before the day is done it is decreased back down to 1 mil, would I be charged on the 1mil or the 2mil? Does the calculation happen at a specific time of day and…
-
Mass Renaming Columns
Is there any way for me to mass rename columns? Instead of going into the "Select Columns" tile and going down the list 1 by 1 can I copy paste a text file somewhere that will do this? In any other case I would be fine renaming, but right now my dataset has an output of almost 700 columns.
-
How exactly are credits charged when it comes down to the "3rd lowest usage day"
Hello, I am here to ask to see if I can get a clear understanding of the way credits are charged for storage. I see in the consumption article that it states "For credit calculation for materialized and virtual storage rows, the number of storage rows per month is determined based on the 3rd lowest usage day of the…
-
Subscribe to status.domo.com
Hello, Just wondering if there is a way to "subscribe" or somehow get an email when DOMO is having issues or anything is going on and it is reported in the status.domo.com page. Thank you
-
Renaming Columns and NOT breaking cards
I am barely getting started with the vast DOMO world so forgive me if this is an obvious thing. I was recently creating a dataflow and some cards from that dataflow and decided to test something out. I created the card using a column from that dataflow and then proceeded to change the name of that column in the dataflow.…
-
Workbench Notifications
Hello all, I am here to ask if there is something in place that can be setup as far as notifications go when a workbench job has not completed (regardless of failure or succeeding). I know you can the notification on success or on failure but is there anything like "send email when job taking longer than 1 hour to run" or…
-
Dataset Tabs appear to be hidden for some datasets
Hello, When I click on a specific dataset (for which I have full edit access to) I seem to not see any of the tabs at the top like the overview, data, cards, etc. I thought maybe I have restricted access but if I manually input in the url "/data/table" after details, I can see all of the data. Any idea how to bring these…
-
GLOBAL on success/failure notification rather than each individual dataset
Just wanted to ask if there was a way to set a GLOBAL on failure notification in workbench? Rather than having to check off the box for the specific email on each individual dataset in workbench.
-
Removing Java components
Does Workbench installation rely on Java to function? I ask becuase my company is requesting to remove any and al Java components from our VMs where we are hosting our Workbench application. Would getting rid of Java screw up Workbench?
-
Dataset column description mass load
Is there a way to be able to edit the column description field massively. For example if I have all the descriptions that need to be input but there are datasets that have over 800 columns .... is there a way I can upload these to the dataset?
-
DATETIME field with NULL value
I am running into an issue where when I load up some data via workbench there is a table that has a DATETIME field where the default value is NULL. When workbench is querying that, it absolutely does not like that there is a NULL value in that field. It takes about 20+ hours to run the entire process. I removed the column…
-
Magic ETL hydrating error
Hello, Wondering if anyone has encountered an error like this before and know what it means? (other than that the action is thirsty)
-
Excel Auto Upload
Is there a connector which I can use to automatically upload an excel file from my computer into domo to update a dataset? I know Workbench has the capability of detecting when a file is changed then to rerun the job, but that is on one of our servers and not on my own machine. Is there a connector that can achieve this?
-
Count number of character occurrence in string
Trying to see if there is a way to achieve this. I have a column that has something like the left column here Is there a way to achieve the right side column by looking at maybe the number of commas + 1 maybe? Doing this in ETL formula tile would be best for me if possible
-
Dataset/Card Certification History
Hello, I was wondering if there is any location in Domo where one can go to to view the history of a dataset and its certification status history. For example I have Dataset A and it is currently certified but a change was made in the ETL and it now has an expired certification. I now need to resubmit the certification for…
-
Trigger a workbench job from a sql script
We have a few scripts that run overnight, some run weekly, some daily, and some hourly. Is there a way to allow our workbench jobs to fire off whenever that script is done running? Or would we just have to pad it by a few hours like say it runs every Friday at 11pm, Have the workbench job to run every Saturday at like 6am…
-
Trying to figure out how to get this data set up in card
I have the following data below. I would like something like the grouped bar graph where the bottom would be my "y" column the values would be my "z" column BUT I only want to display the top 3 values of "x" column. So with the current data it should only display the values from where "x" is 4,5, and 6 ..... so when this…
-
Card similar to the dataset history chart
I was wondering if there is a chart type in the card builder to build something similar to the chart in the dataset history tab like this
-
At what stage should column renaming happen
Hello I am wondering at what stages of everyone's workflow does the renaming of columns happen. A. Workbench B. DOMO ETL C. DOMO Card I ask because we have tons of tables being brought into DOMO that do not have "business column names" I feel like if the names are changed in Workbench(A) then it is the root change and will…
-
Workbench Job to DOMO stuck on "Connecting"
I have a workbench job that has been in the "connecting" state on the DOMO side for over 4 days. Is there anyway to kill it? The job on the workbench side has already been stopped.
-
Workbench Monitor will not open
I am trying to restart the workbench service because I have encountered the same issue as this post and I saw the solution. But for some reason when I click on Workbench Monitor, I get the icon on the bottom right in the menu but when I hover over the icon to right click, it disappears. Has anyone encountered this before?…
-
Append with removing rows of data
I am wondering if there is way to setup the following scenario. I have an append that runs in the morning and all the new data gets added properly, however, there are situations where some of the source data is no longer needed for example if I started with 110 rows of data yesterday and throughout the day 10 were removed,…
-
Dataset Upsert
I have been reading up on this and noticed that I in fact do NOT have the Upsert column enabled therefore according to the document I need to contact customer support. My question is, will I need to do this for every single current dataset and all future ones as well? Or is this a "flip the switch" kind of deal and it will…
-
Run Workbench Job from another computer or script where workbench does not reside
I am trying to see if there is a way I can run a workbench job from a computer in which workbench is not installed. I have some SQL queries that run overnight or a specific times throughout the day and I would like to have a script that triggers the run of the workbench job. Is there some sort of API endpoint I can call or…