xavier-GitHub76 opened a new issue, #30637:
URL: https://github.com/apache/superset/issues/30637

   ### Bug description
   
   Have a table with colum name using a space (It's not a good pratice but it 
is possible)
   
   To succed, the SQL query must use quote (Select "name with space" from...)
   
   When creating a simple metric,  the Custom SQL is generated
   The metric is OK a result is well returned
   
![image](https://github.com/user-attachments/assets/ea6b1221-d824-4fb2-a53d-5a0b3ca05139)
   
   but the Custom SQL is wrong, It does not use quotes
   
![image](https://github.com/user-attachments/assets/8c4f3728-9c4e-4361-b8b9-995f0512219a)
   
   If a user create saved metric with this Custom SQL, the saved metric is 
unusable
   
![image](https://github.com/user-attachments/assets/f3daf121-3f76-442d-b424-3db75c15c7c8)
   
   Sincerly
   
   ### 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: [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]

Reply via email to