Tim's avatar
Tim
Data Integration
03-26-2024
Status:
Needs Info

Refresh schema for all tables

Can we get a "refresh schema for all tables" button?

Reason:
Our tables are usually "Select * From AnalyticsSchema.ViewName". We control which fields to return by editing the view, not the Sisense table definition. When a field gets added/removed/changed, we need to refresh schema. That's fine to do manually as you're working on that datamodel+views, but we need to refresh all when:

  • We copy a datamodel to a different server. We need to refresh schema at least to double-check that the views are as expected on the new server. (If any fields have changed, then I'll need to go fix any widgets using those fields, or, more likely, update the view to include them.)
  • A view gets edited, perhaps for a different datamodel, and my datamodel hasn't been updated. 
  • I edit several views and want to refresh schema for all those Sisense tables. If I've changed used fields then I'll need to go into each table manually anyway so it doesn't matter, but I've had a case where I've removed unused fields from several views and now I need to click refresh schema on every table individually.

15 Comments

  • I tried to refresh the schema for all the product tables on the Goodwill Outlets website, but it doesn't seem to be working. The changes I made to the database schema are not reflected on the product pages.

    Possible Causes:

    There might be a cache issue preventing the schema from refreshing properly.

    The schema update process might not have been triggered or completed correctly.

    The permissions on the database may not be set up correctly to allow schema updates

  • Totally support this idea—manually refreshing schemas for dozens of tables is a total time sink in Sisense! It'd be a game-changer for our ETL workflows. In the meantime, while we're all grinding through these manual updates.