dosubot[bot] commented on issue #30637: URL: https://github.com/apache/superset/issues/30637#issuecomment-2418998118
<!-- Answer --> To address the issue of Custom SQL not using quotation marks for column names with spaces, you can ensure that the SQL generation logic in Superset correctly applies quotes to column names. Superset's SQL generation logic typically handles this by checking if column names are already quoted and applying quotes if they are not. This is done in the `_get_fields` method, which processes column names and ensures they are quoted correctly <sup>[[1]](https://github.com/apache/superset/blob/master/superset/db_engine_specs/presto.py)</sup>. If you are using the Snowflake engine, the `force_column_alias_quotes` attribute is set to `True`, which ensures that column aliases are quoted, thus handling column names with spaces correctly <sup>[[2]](https://github.com/apache/superset/blob/master/superset/db_engine_specs/snowflake.py)</sup>. If this issue persists across different database engines, you might need to check if there are specific configurations or patches required for the engine you are using. Additionally, reviewing the SQL generation logic in the Superset codebase for your specific setup might provide further insights into how to enforce quoting for column names with spaces. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* -- 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]
