GitHub user dosubot[bot] added a comment to the discussion: Superset + Opensearch integration
<!-- Answer --> The `'odelasticsearch'` dialect is commented out in Superset's dialect mapping, so Superset defaults to a generic SQL dialect for query parsing and generation. This fallback uses backticks for quoting identifiers (e.g., `FROM \`default\`.logs`), which Opensearch SQL does not support, leading to parsing errors when creating datasets or running internal queries [[source]](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/sql/parse.py). Currently, there is no built-in workaround in Superset for this issue. The `SQL_QUERY_MUTATOR` config can alter outgoing queries, but it does not reliably affect internal queries like those used for dataset metadata [[source]](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/config.py). Superset does allow for extending SQL dialects via `SQLGLOT_DIALECTS_EXTENSIONS`, but this only works if the dialect is referenced in the code, which is not the case for `'odelasticsearch'` right now. To resolve this long-term, a new or updated dialect for Opensearch would need to be contributed to Superset, either by implementing a custom engine spec/plugin or by submitting a pull request to add proper dialect support [[source]](https://github.com/apache/superset/discussions/31619). Until then, the backtick quoting issue will persist for internal queries with Opensearch connections. <!-- 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/18231ef1-9d1e-4079-8566-03509107eb1a?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/18231ef1-9d1e-4079-8566-03509107eb1a?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/18231ef1-9d1e-4079-8566-03509107eb1a?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/18231ef1-9d1e-4079-8566-03509107eb1a?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/18231ef1-9d1e-4079-8566-03509107eb1a?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/18231ef1-9d1e-4079-8566-03509107eb1a?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/18231ef1-9d1e-4079-8566-03509107eb1a?feedback_type=other)</sup> [](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/discussions/34083) GitHub link: https://github.com/apache/superset/discussions/34083#discussioncomment-13680873 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
