GitHub user dosubot[bot] added a comment to the discussion: Migrate Redash to Superset
<!-- Greeting --> Hello @gnipps-carsome! I'm [Dosu](https://dosu.dev), your friendly bot here to help you solve bugs, answer questions, and navigate this migration adventure. I'm here to assist while you wait for a human maintainer. How can I help you today? <!-- Answer --> Superset provides a feature for bulk importing queries from external sources, which can be useful for migrating a large number of queries. The `ImportSavedQueriesCommand` is used for importing saved queries, and it can handle multiple queries with validation checks for the imported data. The import process is facilitated through a REST API endpoint that allows users to upload a ZIP file containing the necessary YAML files for metadata, databases, and queries. This process also supports options like overwriting existing queries and handling SSH tunnel configurations <sup>[[1]](https://github.com/apache/superset/blob/master/tests/integration_tests/queries/saved_queries/commands_tests.py)</sup><sup>[[2]](https://github.com/apache/superset/blob/master/superset/queries/saved_queries/api.py)</sup>. However, there is no specific guide or documentation in the Superset repository for migrating data directly from Redash. You may need to export your queries from Redash in a format that can be converted into the YAML format required by Superset's import feature. Unfortunately, there are no scripts or tools provided in the Superset repository specifically for automating the migration of queries from Redash <sup>[[1]](https://github.com/apache/superset/blob/master/tests/integration_tests/queries/saved_queries/commands_tests.py)</sup><sup>[[2]](https://github.com/apache/superset/blob/master/superset/queries/saved_queries/api.py)</sup><sup>[[3]](https://github.com/apache/superset/blob/master/superset/commands/importers/v1/assets.py)</sup>. For a smooth migration, you might consider developing a custom script to transform Redash's exported queries into the format required by Superset. <!-- 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/e147ba4b-2dee-4a45-807b-750ff8278e10?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/e147ba4b-2dee-4a45-807b-750ff8278e10?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/e147ba4b-2dee-4a45-807b-750ff8278e10?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/e147ba4b-2dee-4a45-807b-750ff8278e10?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/e147ba4b-2dee-4a45-807b-750ff8278e10?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/e147ba4b-2dee-4a45-807b-750ff8278e10?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/e147ba4b-2dee-4a45-807b-750ff8278e10?feedback_type=other)</sup> GitHub link: https://github.com/apache/superset/discussions/33073#discussioncomment-12786171 ---- 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]
