gidinetapp opened a new issue, #31569: URL: https://github.com/apache/superset/issues/31569
### Bug description When updating a virtual dataset column names (adding or modifying), after saving the dataset, I need to go to "edit dataset" again and click on "sync columns from source" and save again. Only then can I use the new columns in charts. There are a few issues regarding this process: 1. **Syncing Before Saving**: Currently, syncing columns requires too much manual intervention: save the dataset, re-enter it to sync the columns and save again. Allowing column syncing **before** saving the dataset would save time for users. 2. **Syncing with No Data Bug**: If the query in the dataset returns no data, clicking "sync columns" shows that there are no columns at all. This requires making a fake query that will return any result, syncing columns, and then changing back the query. 3. **Automatic Syncing**: Once the syncing with no data bug is solved, it would be very helpful if the columns could be synced automatically when the dataset is saved. This would streamline the workflow and ensure that the dataset is always up-to-date without requiring additional steps. ### Screenshots/recordings  ### Superset version 4.0.2 ### Python version 3.11 ### Node version I don't know ### Browser Chrome ### Additional context [Similar issue](https://github.com/apache/superset/issues/21907) for superset 2.0.0 (closed because version was no longer supported) ### Checklist - [X] I have searched Superset docs and Slack and didn't find a solution to my problem. - [ ] I have searched the GitHub issue tracker and didn't find a similar bug report. - [ ] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
