Adding a column to a datasource in Domo Workbench breaks ETL transform (Redshift SQL)
Hello!
I was hoping anyone might be able to help me out with this. I am using Domo Workbench to extract from a SQL Server ODBC source (instance is on-premise behind a VPN), and added a column that was needed to an existing source, but after reuploading the data to Domo, an ETL Redshift transform using it now errors, saying "DataSet doesn't exists" with no other details. I can only assume that it was the Data source that was modified, so I've tried to delete it from the transform and try again, and ran through each part to "Run SQL" and all works fine, but when running the transform always errors within a second
Best Answer
-
Sorry, this was not a problem with the data source. The issue was that one of the outputs was deleted, so recreating those deleted outputs in the transform fixed the issue.
0
Answers
-
I would say start by checking that hte updated dataset is indeed there and that it has the data you expect it to have and the column names are as you expect them. Workbench is known, at least to me, to throw curve balls like that.
0 -
Sorry, this was not a problem with the data source. The issue was that one of the outputs was deleted, so recreating those deleted outputs in the transform fixed the issue.
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 308 Workbench
- 7 Cloud Amplifier
- 10 Federated
- 3.8K Transform
- 661 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 820 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 781 Automate
- 193 Apps
- 483 APIs & Domo Developer
- 85 Workflows
- 23 Code Engine
- 43 AI and Machine Learning
- 22 AI Chat
- 3 AI Projects and Models
- 18 Jupyter Workspaces
- 409 Distribute
- 116 Domo Everywhere
- 282 Scheduled Reports
- 11 Software Integrations
- 146 Manage
- 142 Governance & Security
- 9 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive