mtrentz opened a new issue, #27973: URL: https://github.com/apache/superset/issues/27973
### Bug description When I edit a column name/alias that is just a "simple column" on the `CUSTOM SQL` tab the alias will not apply to the visualization. If I add a custom sql that is `album_name || ''` (postgres concatenation) then the alias will apply. I am aware that I could just add a label at the dataset level but I have two problems with this: - We lock datasets because they are managed by dbt - Sometimes, depending for what you're doing, you want to change the name of a column to better express it's meaning. - For example: filtering an employee table to only show managers and then rename the column to `Manager` instead of the dataset label of `Employee Name`. This seems to happen only for tables with Raw Records. Tried both on versions 4.0.0 and 3.1.1 ![image](https://github.com/apache/superset/assets/59535526/445293d2-26fa-44f1-9385-c63fc0b49e38) ![image](https://github.com/apache/superset/assets/59535526/e6cf959c-bceb-4b4c-8ecd-52df75ac00e3) ### How to reproduce the bug 1. Create a Table 2. Select Raw Records and select a column from the data set 3. Click on `Custom SQL` and then click the pencil to edit 4. Change name to something else 5. Update Chart 6. Notice how the new name won't appear in the visualization ### Screenshots/recordings _No response_ ### Superset version master / latest-dev ### Python version 3.9 ### Node version 16 ### Browser Chrome ### Additional context _No response_ ### Checklist - [X] I have searched Superset docs and Slack and didn't find a solution to my problem. - [X] I have searched the GitHub issue tracker and didn't find a similar bug report. - [X] 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: notifications-unsubscr...@superset.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org