dosubot[bot] commented on issue #35910: URL: https://github.com/apache/superset/issues/35910#issuecomment-3468497210
<!-- Answer --> This is a known regression in Superset 6.0.0rc1/rc2 affecting physical datasets for engines with supports_cross_catalog_queries=True (like Trino). The bug causes the full table identifier to be constructed and quoted as a single string, leading to errors where the schema/catalog is duplicated in the generated SQL, which matches what you're seeing. Virtual datasets work because they bypass this identifier quoting logic and use direct SQL instead. A temporary workaround that has worked for other engines (such as Snowflake) is to disable supports_cross_catalog_queries in the engine spec. This restores the correct behavior for physical datasets and avoids the double prefixing/quoting issue. Superset maintainers have acknowledged this as a regression and are working on a fix. You can track similar discussions and see a workaround example in [this issue](https://github.com/apache/superset/issues/35116). If you need to keep using physical datasets with Trino, you can try patching the engine spec to set supports_cross_catalog_queries = False for Trino as a stopgap until an official fix lands. <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/4520cd34-5bad-407a-8a9f-14d791d11c62?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/4520cd34-5bad-407a-8a9f-14d791d11c62?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/4520cd34-5bad-407a-8a9f-14d791d11c62?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/4520cd34-5bad-407a-8a9f-14d791d11c62?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/4520cd34-5bad-407a-8a9f-14d791d11c62?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/4520cd34-5bad-407a-8a9f-14d791d11c62?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/4520cd34-5bad-407a-8a9f-14d791d11c62?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=githu b) [](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/issues/35910) -- 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]
