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.

21 Comments

Comments have been turned off for this idea
  • 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!

  • That would actually be a really useful feature, especially when working across multiple environments. Manually refreshing each table becomes tedious and increases the chance of missing something. A bulk refresh option or even an automated sync based on schema changes would save a lot of time.

    When I’m dealing with repetitive tasks like this, I usually take short breaks to stay focused—sometimes even quick tools like the Hit the button maths game help reset my concentration between iterations.

  • This is a real pain point, especially when you are working with multiple views across environments. I faced something similar where schema changes were not synced properly and it caused issues later in dashboards. A bulk refresh option would save a lot of time. By the way, I recently saw how structured data is handled in other industries like ShelterTent tent manufacturers, they keep things very organized from the start, which reduces this kind of hassle later.