Skip to main content
Version: v1.2.0

Superset dashboards

After running drift queries in Superset SQL Lab, you can save results as datasets, create charts, and build monitoring dashboards for ongoing visibility into model drift.

Save query results as a dataset

To reuse a drift query result in charts and dashboards, save it as a dataset:

  1. Run your drift query in SQL Lab.

  2. From the Save drop-down, select Save dataset.

    Save as dataset

  3. Enter a descriptive name for the dataset (for example, tvd_drift_age_column or psi_categorical_drift).

  4. Click Save.

Save dataset dialog box

tip

Use a consistent naming convention for datasets, such as <drift_method>_<feature_name> (for example, tvd_drift_age, psi_drift_gender). This makes it easier to identify datasets when building dashboards.

Create a chart

To visualize drift data as a chart:

  1. Go to Charts and click + Chart.

    Open charts

  2. Select the dataset you saved.

  3. Choose a chart type.

    Select dataset

    Recommended chart types for drift monitoring:

    Chart typeBest forExample use case
    Line chartDrift score over timeVisualize how TVD or PSI changes across time buckets
    Bar chartComparing drift across columnsSide-by-side comparison of drift scores across features
    TableDetailed drift dataShow exact drift scores, sample sizes, and status labels
    Big Number with TrendlineSingle-metric overviewDisplay the latest drift score with trend
  4. Configure the chart:

    • Set the Time column to timestamp (or time_bucket).
    • Set the Metric to the drift score column (for example, drift_score, psi_score, z_score_drift).
    • Optionally group by column_name to plot more than one feature on a single chart.
  5. Click Save, and add it to a new or existing dashboard.

Build a monitoring dashboard

To create a centralized view of your model's drift metrics:

  1. Go to Dashboards and click + Dashboard.

    Create dashboard button

  2. Add your drift charts to the dashboard.

  3. Arrange charts in a logical layout.

    Advanced dashboard

SectionCharts to include
OverviewBig Number charts for latest drift scores per key feature
Numerical driftLine charts showing TVD or Z-Score drift over time
Categorical driftLine charts showing PSI drift over time
Detail tablesTable charts with exact scores, sample sizes, and drift status

Dashboard best practices

  • Naming: Use descriptive dashboard names that include the model or deployment name (for example, Credit Model - Drift Monitoring).
  • Refresh schedule: Set an auto-refresh interval that matches your scoring frequency. For example, if you score hourly, set the dashboard to refresh every hour.
  • Filters: Add dashboard-level filters for column_name to allow users to focus on specific features.
  • Annotations: Add annotation layers to mark important events such as model retraining dates or data pipeline changes.
  • Sharing: Grant workspace access before sharing a link, or add team members as owners. See Share a dashboard.
Dashboard visibility

Saved dashboards, charts, datasets, and saved queries are visible only to their creator by default. Other non-administrator users don't see your dashboards in their dashboard list, and your charts don't appear in their chart list. To share a dashboard with team members, see Share a dashboard. Administrators can see all objects across the platform.

Share a dashboard

Superset enforces dashboard access at the workspace level, based on the workspace roles assigned in H2O AI Cloud. A user can view a dashboard only if they have access to the workspace that contains the data the dashboard uses. Sending a dashboard link isn't enough on its own—without workspace access, the recipient can't open the dashboard, even with a valid link.

Grant workspace access

Before sharing a dashboard, grant the target user access to the workspace whose data the dashboard uses. You grant this access in H2O AI Cloud, not in Superset.

  1. In the H2O AI Cloud App Store, open the workspace and click Edit Workspace.

  2. Under Members and permissions, select the user.

  3. Assign a permission. The user needs at least the MLOps Reader role to view dashboards backed by that workspace's data. Higher roles, such as Workspace Owner, also grant access.

  4. Click Add User.

    Assign the MLOps Reader role in the Edit Workspace dialog

For more information about managing workspace membership, see Workspaces in H2O AI Cloud.

After a user has workspace access, share a direct link to the dashboard:

  1. Open the dashboard.

  2. Click the three-dot menu ().

  3. Select Share, then choose Copy permalink to clipboard or Share permalink by email.

  4. Send the link to the user.

    Copy a dashboard permalink from the three-dot menu

Add a user as a dashboard owner

Add a user as an owner so the dashboard appears in their dashboard list and they can edit it:

  1. Open the dashboard and click Edit dashboard.

  2. Click the three-dot menu () and select Edit properties.

  3. Expand Access & ownership.

  4. Under Owners, search for the user by name or username and add them.

  5. Click Apply.

    Add a user under Access &amp; ownership in Dashboard properties

Data export

An administrator can turn data export on or off in Superset by changing the relevant values in the Helm chart or by editing the user's role.

Next steps


Feedback