I get this error:
Refresh Schema Failed
The table probably no longer exists. Please use the change connection flow.
When I click Refresh Schema on some tables. Can anyone help diagnose/fix?
Some info:
I've diagnosed it:
In the .smodel json, each dataset has a "schemaName" property. Also, each table in the dataset has a "schemaName" property.
When you load data or add new tables to your model, it uses table.schemaName.
But Refresh Schema uses datasets.schemaName.
When schemaName is the same for both, everything works fine. But if they differ (e.g. if a single datasource has tables from two different schemas), then Refresh Schema fails (unless the table also exists in the other schema).
Question for Sisense: Presumably this is a bug. Refresh Schema should use table.schemaName, not dataset.schemaName. Are you aware? Has it been fixed in later versions (I found it on 23.9)?
I created a new livemodel with one of the tables that's playing up (and nothing else in it). I can refresh schema just fine there.
