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 to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
@mhouston thank you very much
[and thank you to the other commenters as well]
I submitted a ticket yesterday, and have been told that it was moved to the technical team, but have not heard anything since.
Glad to hear it is not just me, hopefully they can find a solution for us soon
Regards
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 99 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 727 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive