Models have empty datasets | Help and How-To

Tim von Ahsen · 2024-04-08T00:32:47.046000Z

Summary:Feature request / bug report: When change dataset, delete unused datasets.Details:When I look at my .smodel files, I notice they have extra datasets that are empty. For example, in the dataset JSON below notice "tables": [].The reason is that my dashboards often change their source - e.g. if development switches to a new source database, or if different people makes changes on versions of the dashboard linked to different databases, but merge their changes.When the user changes a datasource, Sisense should check if the old datasource is still needed and, if not, delete it. Either that check isn't working, or it was never implemented. Problems caused? (a) Can't convert to LiveModel if there are multiple datasets. (b) We develop locally then deploy to clients; it's not good for the datamodels to store information about past connections after we change their connection info. (c) I suspect this is not the intended behaviour, so it could lead to other unforseen issues/confusion. (d) The only way to fix these issues is to edit the JSON to remove empty datasets. { "oid": "xxx", "fullname": "sql:xxx", "database": "xxx", "schemaName": "xxx", "type": "extract", "name": "xxx", "modelingTransformations": [], "schema": { "tables": [] }, "connection": { "oid": "xxx", "id": "xxx", "provider": "sql", "parameters":

MoreDiscussions

Models have empty datasets | Help and How-To | Sisense Community