-
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…
-
Workbench - Source File Does Not Exist
Has anyone found a solution for the "Source File Does Not Exist" error? I am using the 'Excel: On-Premise' processing method and using a network drive for storage. Even when I reconfigure and reselect the file it does not resolve and I get the above reference error. Any ideas? Thanks all!
-
How to properly partition in Workbench while allowing older data to come in?
I have a SQL Server dataset of 50M rows. Workbench runs the APPEND Update Method HOURLY. I use the table ID as the UPSERT key and the processing query checks the past 7 days ("Insertion Date") for new records. This updates older data unnecessarily with the same data, but protects against issues with the job not running for…
-
Accessing Dataset
Hello everyone, I am using Domo Workbench, and currently I am trying to run a dataset while using an ODBC connection. When I execute the job, it runs fine, however, when I go to Domo datasets I do not see it there. When I execute from Workbench it is executing as another user (another owner). Is there a way I can still see…
-
How to periodically REPLACE in addition to APPEND jobs?
I have a VERY large dataset that I've uploaded to Domo. I initially did a REPLACE to load the whole dataset. I then changed the workbench job to APPEND and use an 'update date' in the table to run HOURLY while checking back the past couple days for any new/missed data. Due to some bugs on our side, sometimes very old data…
-
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…
-
Workbench Restarts when "Source File Doesn't Exist"
Hello! I'm running into an issue where I have workbench on a server with ... "issues." Sometimes I get "Source file does not exist" (the file absolutely exists) and then that workbench job doesn't run again until the job is manually ran. Any way to get this job to restart even if it thinks the source file doesn't exist? Am…
-
Trim 2 characters from right side of string using Workbench
I have a dataset that appends every day and I want to remove 2 characters (.0) from the right side using Workbench. I thought this would be simple, but Search & Replace does not allow replacing with null, and replacing with a space or other character is also undesirable. Is there a way to use any of the Workbench…
-
Workbench Data Sync Folders won't stay deleted
As I was first connecting files using Domo Workbench I added a number of folders to Data Sync. I now wish to remove these folders as I there are many files in them that I do not need or want syncing with Domo. I can not delete the folders themselves as the files are used by many people in my organization. I have gone…
-
Workbench - Preview Schema Data Type Error
We have been trying Workbench in different computers including the main server where we will upload data to our Domo instance. In this example, we are uploading data from a CSV file which have different data types (STRING, DATETIME, DECIMAL) and, in general, in all computers the Workbench maps the schema correctly during…
-
Text message when domo workbench job fails
Hello, Does anyone have any ideas on if its possible to receive a text message on my phone when a workbench job fails? I get emails when jobs fail, but I don't keep Outlook notifications on my phone because my phone would just ding all day long. Too many times on a Monday morning I've discovered a job has been failing…
-
Workbench
Training on workbench
-
Workbench - Different jobs ID when importing
We are moving from one on-premise server to another on-premise server and we need to set the same Domo Workbench jobs in the new on-premise server. We exported the jobs to a local backup file in the old server, then we copy the file to the new server and then we imported the jobs from the file to Domo Workbench. Everything…
-
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,…
-
Is there any way to schedule file uploads to Domo apart from Workbench?
So just as the question states, I am a new user in the planning stage and I am trying to figure out if Workbench is the solution I have to upload my .xls files to Domo. Is it possible to access Files saved on Microsoft Sharepoint or Teams for example?
-
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…
-
Workbench Replacement Variable not saving
I've created a handful of Workbench jobs over the past few months, but every time I do, I seem to have to struggle for about an hour each time to get the replacement variables working with the 'Append' update method. This typically includes trying every imaginable order of operations, deleting and recreating the job…
-
Can Just One Workbench Be Used On One Domain?
Does anyone know more about having multiple users working on Workbench at the same time? The FAQ page states that it is "All Workbench jobs are saved in the cloud and tied to a specific login", but I'm not sure what this means. https://domohelp.domo.com/hc/en-us/articles/360043437373-Workbench-5-FAQs From what we have…
-
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…
-
Overwriting an Existing DataSet with Workbench
In our team, we have a couple of engineers developing in Workbench on different PCs. When I exported a job from one Workbench, imported it to another Workbench on a different PC and ran it, another DataSet with the same name was created. Is there anything I can do to overwrite and update the existing DataSet?