New columns not showing up when they are added to an underlying data table?

Last updated: March 26, 2025

When you add new columns to your underlying data source, you may need to refresh the dataset in Explo to make these columns available in your tables and visualizations.

Quick Solution and workaround

To refresh the dataset and pull in new columns:

  1. Open your dataset's SQL query

  2. Make a minor modification to the query (such as adding a space)

  3. Save the dataset

This workaround is necessary because the system only allows you to save when it detects a change in the query. Simply adding a space and removing it will trigger a refresh while keeping your query functionally identical.

What This Affects

This process will update:

  • Available columns in new tables/visualizations

  • Column options in existing tables

  • Dataset schema

Your existing table formatting and customizations will be preserved when refreshing the dataset this way.

We are working on a longer term solution as well to auto detect changes in the underlying tables that will remove the need to resave the dataset queries.