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.

19 Comments

  • DRay's avatar
    DRay
    Journey Map

    Hello Tim,

    Can you look at the option provided by Oleksandr_K and let us know it addresses your request?

    Thank you.

  • Tim's avatar
    Tim
    Data Integration

    Cool! I will try it once we upgrade.

  • “Hi everyone — this is an excellent suggestion! Refreshing the schema for all tables would really help maintain data integrity and make analytics more reliable.
    In many real-world scenarios, schema changes go unnoticed until reports break, so a global refresh feature could save a lot of debugging time and ensure consistency.
    Thanks for putting this idea forward — I hope the team Meme APK  considers it for upcoming updates!

     

  • This is a very useful suggestion — being able to refresh the schema for all tables in one place would save so much time when working with complex data models in Sisense, especially when multiple tables change frequently. Right now most workflows require refreshing tables one by one, which can be tedious for analysts and developers. �
    Also, when you’re managing data tools or dashboards, having the right references and utilities from a reliable tool based website can help improve your workflows and planning even more. Keep up the great discussion!