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 ...
Hi! Unfortunately, there isn’t a built-in option in Sisense to refresh all table schemas at once. The safest and most efficient way is to use the Sisense REST API to automate schema refreshes for all tables programmatically. This avoids manual work while keeping your data model consistent.
If you’re concerned about structure or dependencies, test the script on a staging model first to ensure no fields or relationships break. It’s a smart approach—similar to how apps like this website seamless syncing through controlled updates.
poppyplaytime - could you elaborate on using the Sisense REST API to automate schema refreshes for all tables programmatically?
I've been trying to do this via /api/v2 endpoints but still getting the "Refreshing Schema: Differences Detected" popup: