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 need to rename a column. However, when I do this (with allowing for unprotected changes) the changes do not seem to stick. I can get the column I want to remove, to have the corresponding row in the schema highlight red (to be removed). And I can get the column I need to change its name, to have the corresponding row to highlight green (as in new - not changed). But then when I execute, nothing in the schema actually changes. And no errors are given anywhere from what I can see.
If someone has also ran into this, and has a solution, please let me know
Thank you in advance
Regards
Answers
-
Hi @AnaKS
This sounds like a bug with Workbench. I'd recommend logging an issue with Domo Support. In the interim you could utilize a dataset view to drop the column and rename another after you import it into Domo.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
@AnaKS if you are using Workbench, on the configure tab under additional settings, make sure Allow Schema Changes is selected.
I would also suggest you click on the preview icon and then go to the schema tab to see what has been updated. You can also try locking column types on the schema tab to see if that helps.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- 10.5K All Categories
- 6 Connect
- 916 Connectors
- 250 Workbench
- 463 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 189 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 172 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive