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
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 434 Beast Mode
- 22 Variables
- 511 Automate
- 114 Apps
- 389 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive