Bulk upload dataset metrics through the UI from a structured file such as CSV

What is the problem or goal you're trying to solve or accomplish?

The customer wants to automatically create and maintain a large number of saved metrics on an existing dataset, instead of adding them one by one manually in the Preset UI. Their longer-term goal is to make this repeatable across multiple datasets and future metric updates, ideally using a standardized external source of truth.

Today, Preset documents dataset-level metrics as part of the semantic layer, and Superset documents dataset API/import capabilities, but there does not appear to be a documented native UI workflow to upload a CSV and directly create dataset metrics in bulk.

How are you solving it currently?

They would need to manually create each metric inside the dataset, one by one, through the UI.

They are also open to using API-based automation, but they are asking what options exist today and would benefit from a simpler first-class workflow in the product, especially for repeatable metric management coming from a non-dbt external source of truth.

What is your recommended solution?

Add a native UI workflow that allows users to bulk create dataset metrics from a structured file, such as CSV.

A possible workflow could be:

• User opens a dataset and selects a new option like “Import Metrics”

• User uploads a CSV or similar file

• The file maps fields such as metric name, SQL expression, description, format, certification metadata, and other supported metric attributes

• Preset validates the file before import and shows errors clearly

• User reviews the proposed metric creations/updates before confirming

• Optionally support update/overwrite behavior for existing metrics