dosubot[bot] commented on issue #31183: URL: https://github.com/apache/superset/issues/31183#issuecomment-2504282989
<!-- Answer --> To handle the issue as before the upgrade, you can try the following steps: 1. **Review SQL Syntax**: Ensure that the SQL queries being executed are fully compatible with the TSQL dialect as interpreted by the `sqlglot` library. Simplify the queries if possible to identify any specific syntax causing the issue. 2. **Check Permissions**: Since the issue seems to be related to permissions on the `dbo` schema, review the permission settings. You might need to adjust the permissions to match the previous configuration before the upgrade. If full access resolves the issue, consider incrementally adjusting permissions to identify the minimum required settings. 3. **Superset Logs**: Examine the Superset logs for any additional error messages or warnings that could provide more context on the parsing failure. This might help identify specific SQL statements or permission settings causing the issue. 4. **Rollback**: If the above steps do not resolve the issue, consider rolling back to version 4.0.1 temporarily while further investigating the changes between versions 4.0.1 and 4.1.1 that might have affected SQL parsing or permission handling. These steps should help you manage the issue while maintaining the necessary permissions and SQL functionality. <!-- 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: notifications-unsubscr...@superset.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
