dosubot[bot] commented on issue #35644:
URL: https://github.com/apache/superset/issues/35644#issuecomment-3402513030
<!-- Answer -->
To import multiple database connections into Superset (v5.0.0) using your
automated process, structure your ZIP file like this:
```
databases/
metadata.yaml
Reporting.yaml
Superset_metadb.yaml
...
datasets/
Reporting/
Inventory_Cyclecount_by_Task_Priority_and_Zone.yaml
Inventory_Task_Ended.yaml
Superset_metadb/
... (datasets for this DB)
```
Each database connection gets its own YAML file under `databases/` (e.g.,
`Reporting.yaml`, `Superset_metadb.yaml`). Datasets for each database go in
their own subfolder under `datasets/` (e.g., `datasets/Reporting/`,
`datasets/Superset_metadb/`). This structure is explicitly supported by the
import logic in Superset 5.x and is the standard approach for bulk importing
databases and datasets via the UI or API
[[source]](https://github.com/apache/superset/blob/master/superset/databases/api.py)
[[source]](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/commands/database/importers/v1/__init__.py).
When importing, you can provide passwords for each database as a JSON map,
keyed by the path to the YAML file (e.g., `{"databases/Reporting.yaml":
"password1", "databases/Superset_metadb.yaml": "password2"}`).
No special naming convention is required beyond placing each database YAML
in the `databases/` directory and organizing datasets by database name under
`datasets/`. This approach works for automated imports and is robust for
handling multiple databases in Superset.
<!-- 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/4a81924d-4331-4d53-937a-82fcba8a66c7?feedback_type=great_response)
|
[Irrelevant](https://app.dosu.dev/response-feedback/4a81924d-4331-4d53-937a-82fcba8a66c7?feedback_type=irrelevant_answer)
|
[Incorrect](https://app.dosu.dev/response-feedback/4a81924d-4331-4d53-937a-82fcba8a66c7?feedback_type=incorrect_sources)
|
[Verbose](https://app.dosu.dev/response-feedback/4a81924d-4331-4d53-937a-82fcba8a66c7?feedback_type=too_verbose)
|
[Hallucination](https://app.dosu.dev/response-feedback/4a81924d-4331-4d53-937a-82fcba8a66c7?feedback_type=hallucination)
| [Report
🐛](https://app.dosu.dev/response-feedback/4a81924d-4331-4d53-937a-82fcba8a66c7?feedback_type=bug_report)
|
[Other](https://app.dosu.dev/response-feedback/4a81924d-4331-4d53-937a-82fcba8a66c7?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/35644)
--
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]
