Ability to Hide/Unhide Dataset Columns from the Preset UI

What is the problem or goal the end user is trying to solve or accomplish?

Users want to temporarily hide specific columns from a dataset so they are not visible/available when building charts or exploring data, without having to delete the column from the dataset or underlying table. This is useful when:

• A column is sensitive and should not be exposed to most users.

• A column is deprecated or confusing but still needed technically in the underlying table.

• Users want to declutter the list of columns and simplify the Explore experience.

The goal is to have quick control, at the dataset level, over which columns are visible in the UI for chart building and exploration.

How are they solving it currently?

Currently, users have to rely on workarounds such as:

• Creating a separate virtual dataset that excludes the column(s) they don’t want to show.

• Physically dropping or altering the column in the underlying database table (often not acceptable).

• Using data-level security or roles to restrict access, which is more complex and not meant for “just hide this column from the UI.”

• Renaming columns or adding descriptions to “warn” users instead of truly hiding them.

These approaches are more complex, harder to maintain, and not as flexible as a simple hide/unhide toggle in the UI.

What is the recommended solution by the Customer?

Add an option in the Preset dataset UI to hide/unhide columns on demand, for example:

• A per-column toggle like “Visible in Explore / charts” (on/off).

• Hidden columns should not appear in the Explore column list, metric builder, or filters for users who don’t have permission to edit the dataset.

• Dataset editors/owners should still be able to see all columns (including hidden ones) with a clear indicator that a column is hidden and an easy way to re-enable it.