GitHub user yixinNB created a discussion: Feature Request: Bulk import of all
tables/views in a database as Superset datasets, and allow filtering by
database when creating charts
As a Superset 5.0.0 user managing multiple databases, I often face two major
pain points:
1. **There’s no easy way to bulk-import datasets.**
Superset currently requires manually creating each dataset (table or view)
through the UI.
When a database contains dozens or even hundreds of tables, this process
becomes extremely time-consuming and error-prone.
The existing “import/export datasource” YAML or ZIP mechanism is helpful for
migration but doesn’t provide an automated way to *scan and register all
tables/views in a database* as datasets.
2. **Chart creation lacks database-level filtering.**
When creating a new chart, the dataset selector lists *all datasets across
all databases* in one long dropdown.
If multiple databases share similar table names or schemas, it becomes
difficult to find the correct dataset.
A database (and optionally schema) filter would make the dataset selection
process much faster and less confusing.
---
**Proposed Solution**
1. **Bulk Import Functionality**
* Add a feature in the UI or API to automatically scan a database (and
optionally a schema) and register all tables/views as datasets in one operation.
* Include configurable options such as:
* Skip already imported datasets
* Auto-generate default metrics for numeric columns (e.g., `SUM()`,
`AVG()`)
* Control whether to sync or overwrite existing datasets
* Support both synchronous and asynchronous execution with progress tracking.
2. **Database Filter in Chart Creation Dialog**
* In the “Create Chart” or “Choose Dataset” dialog, allow filtering by
*database* (and schema).
* This will significantly improve usability when working with many databases
or large Superset installations.
---
**Benefits**
* Saves hours of manual dataset creation and maintenance
* Reduces human errors and improves metadata consistency
* Makes chart creation faster and more intuitive, especially in multi-database
environments
* Enables teams to automate dataset management and keep Superset metadata in
sync with evolving databases
GitHub link: https://github.com/apache/superset/discussions/35645
----
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]
