-
JSon file in Domo
I have a Json File ,what steps should I take to upload in Domo to analyze data
-
Failed to Execute - Domo Workbench
Hi All, I'm getting this error when trying to execute workbench job. "Position is not in format ColumnNameRowName." Any help appreciated. Thanks!
-
Domo workbench - "attempting to open data source"
When a workbench job is executing, does anyone know what is happening when the preview window execution step says "attempting to open data source"? We will have a job that gets stuck on this step for several hours and it is unable to get past this step, then the query times out. The workbench job is executing a stored…
-
Can you use workflows to automatically manage workbench?
Our workbench jobs have a habit of getting hung up when updating making our data fall behind and our end users annoyed. I've already reached out to domo support to help with this issue but in the meantime I have workbench open and I manually update the jobs that miss their scheduled updates. Seeing how this is pretty…
-
Workbench 5 error message when uploading local Excel file...
Attempting to create a job uploading a local excel file using Workbench 5. Getting the error message depicted below… File looks clean to me. There are several formulas in the sheet returning #N/A errors. I've set the below error handling for this. Any ideas what is wrong with the excel file? (I've also tried to upload the…
-
Improve Auth method for SharePoint Connector Plugin via Workbench
We had a problem with the SharePoint plugin for Workbench because it only supports Basic Authentication. In the past, we were connecting to SharePoint just fine but the customer upgraded their authentication method from Basic to Modern and now the jobs we had stopped working. It would be nice for Domo to add the…
-
workbench job - syntax auto fill
Hello In our workbench jobs, we often alias columns and tables with A., B., C., etc. When I type "A." and it autofills to the ADD function, and C. to CASCADE, etc. Does anyone know how to/if you can turn this off?
-
Time change
Hello, currently I am pulling data via an ODBC Connector and pulling through Workbench. What I am finding is, when I query the data locally on the server I am seeing the correct dates, however, when I am pulling it through Domo the datetime is 4 hours behind. How do I correct this? Currently I am in EST time.
-
Incremental refreshes using Domo Workbench
Hi everyone, is it possible to do incremental refreshes using Domo Workbench? I have several datasets with more than 15 or 20 million rows and I'm trying to find a way to only load new data using the Domo Workbench instead of full replace, which is time and resource consuming. I'm using ODBC Connection provider.
-
Workbench Metadata
I would love to have more metadata about my workbench jobs accessible in my Domo instance. A simple thing like being able to filter on "is this a workbench produced dataset" would be a huge thing for Instance Governance. Also having a dashboard to monitor workbench jobs and how they flow through Domo would be great for…
-
Add CSV filename as column
I am running a few workbench jobs, and I need to able to add the file name from each CSV in the folder I'm loading. When you create a workbench job using an xlsx file, you have the option to check a box to add the file name. But for CSV there is no option I can see. Is there a way through calculated columns or any other…
-
Bulk Edit - Additional option for Schema Tab
Under the Bulk Edit feature, would like to see an additional radio button for "Edit Schema settings" For the Schema tab would like to have options for To update the option “Block all Schema changes” to update the check box next to “Protect” (in column header) While upgrading from the older version where these options were…
-
Problems with Workbench, ODBC, MySQL and the data specialist exam
Hi I have a problem with taking this exam: https://learndomo.domo.com/learn/course/383/play/1608/data-specialist-practical-test-2h The task wants you to use Workbench 5 to set up a MySQL job and then import the data from Workbench to Domo. The connection to Domo from Workbench works fine. When I use the parameters for the…
-
for loop in Large amount of Data in Workbench.
Hello all, I'm tiring to pull large amount of data via Workbench, previously this was done with SSIS for loop container pulling only fraction of the time frame data at a time, and appending the results. is there way to achieve this in workbench as I'm not able to find the proper documentation.
-
DOMO Workbench Error: Failed to get a response from the Domo server
I am running a workbench job that is failing with the error message: Failed to get a response from the Domo server. Other jobs on my Workbench are running as normal. I tried to re-run the job, and rebooting my machine. Is there any way to remedy.
-
User is not member of 'Domo Workbench Users' group
We're getting this error User is not member of 'Domo Workbench Users' group Is this something new with workbench? How can we fix this? We're trying to import a backup file. Thank you
-
Workbench Using File Name in Calculated Field Transform
I am connecting to an FTP in DOMO Workbench 5 and wanted to use the Calculated Field transforms. I want to find a way to create a column with the last 8 digits of my file name as I want to include the date. For example, my file is named "File Name 10172023.xlsx" I want this calculated field to create a column showing…
-
Using Workbench Writeback to MS SQL Server
We're trying to writeback data to our MS SQL Server using workbench. We follow the instructions provided here: but we consistently get the same error. [09.29.23 6:45:49 PM] Determining execution parameters [09.29.23 6:45:58 PM] Starting execution of job sql3 WBK | Macola | CICIMPY to Domo DataSet [09.29.23 6:45:58 PM]…
-
Alert or Periodic Email to Customers on Obsolete/ Corrupted/ Harmonization of Domo Apps/ Connectors
Is it possible if Domo can email/ alert clients that are using certain connectors or apps that would get out-dated/ corrupted etc with recommendation from Domo on next steps? Regardless, if the client is on standard, gold or platinum support, these would be helpful for everyone. What we need is proactive communication from…
-
Notify & Not Auto Update Workbench
There have been multiple cases where customers are unable to auto update workbench due to IT policies in updating applications. Having the option to enable notifications for when a new update is available but not auto update would be beneficial for customers to know when new updates have been released allowing them to plan…
-
Workbench with impersonation configuration
I'm setting up an ODBC SQL Server connection with Windows Authentication but it's not working. I am included in the Domo Workbench User group Am I missing any configuration?
-
Date change in workbench
Hi, I am using Domo workbench. When i run a data feed with a query the time seems to change when I see the data on the webpage. So for example, when I run a query and put it in workbench it is saying July 01st 00:00, however, when I look at the data on the data page it says June 31st 08:00. There is a 5 hour difference. I…