dosubot[bot] commented on issue #31183: URL: https://github.com/apache/superset/issues/31183#issuecomment-2504183442
<!-- Answer --> The issue you're encountering seems to be related to SQL parsing for the TSQL dialect in the `mssql.py` engine after upgrading from Superset version 4.0.1 to 4.1.1. Superset uses the `sqlglot` library to handle SQL parsing for different database dialects, including TSQL, by mapping the "mssql" engine to the `sqlglot` dialect `Dialects.TSQL` <sup>[[1]](https://github.com/apache/superset/blob/master/superset/sql/parse.py)</sup>. The error message suggests that there might be a problem with how SQL statements are being parsed for users with specific permissions on the `dbo` schema. When you grant full access to the entire database, the issue is resolved, indicating that it might be related to permission handling or SQL parsing specific to the `dbo` schema. To address this issue, you might want to: 1. Verify that the SQL statements being executed are compatible with the TSQL dialect as interpreted by `sqlglot`. 2. Check if there are any changes in the permission handling logic for the `mssql.py` engine between versions 4.0.1 and 4.1.1 that could affect schema-specific permissions. 3. Review the Superset logs for any additional error messages or warnings that might provide more context on the parsing failure. If the problem persists, consider testing with a simplified SQL query to isolate whether the issue is with specific SQL syntax or permission settings. <!-- 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]
