GitHub user dosubot[bot] added a comment to the discussion: SuperSet connectivity support to Alibaba MaxCompute
<!-- Greeting --> Hello @kellycuilei! I'm [Dosu](https://dosu.dev), here to help you with bugs, answer your questions, and assist with contributions while you wait for a human maintainer. Let’s tackle your issue together! <!-- Answer --> To integrate Alibaba MaxCompute with Superset v4.0, despite sqlglot not supporting MaxCompute, you can consider the following approach: 1. **Modify the SQLAlchemy Extension**: You may need to adjust the existing SQLAlchemy extension to accommodate changes introduced by Superset v4.0. This could involve ensuring compatibility with the Superset Database Engine Specification interface, which includes handling date-related SQL functions, subqueries, and processing logs <sup>[[1]](https://github.com/apache/superset/blob/master/docs/docs/faq.mdx)</sup>. 2. **Custom SQL Parsing**: If sqlglot is a limitation, you might need to implement custom SQL parsing and transformation logic within the extension to handle MaxCompute-specific SQL syntax. 3. **Fallback Mechanisms**: Implement fallback mechanisms for unsupported features by sqlglot, allowing the extension to bypass sqlglot for certain operations and directly interact with MaxCompute. These strategies might require some code modifications but could enable connectivity with MaxCompute using Superset v4.0. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/4a5b1fbc-89c7-4485-b453-147c679faa5f?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/4a5b1fbc-89c7-4485-b453-147c679faa5f?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/4a5b1fbc-89c7-4485-b453-147c679faa5f?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/4a5b1fbc-89c7-4485-b453-147c679faa5f?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/4a5b1fbc-89c7-4485-b453-147c679faa5f?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/4a5b1fbc-89c7-4485-b453-147c679faa5f?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/4a5b1fbc-89c7-4485-b453-147c679faa5f?feedback_type=other)</sup> GitHub link: https://github.com/apache/superset/discussions/33527#discussioncomment-13202051 ---- 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]
