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
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive