Continuous Deployment on Live Data Models
Hello Folks,
How do you migrate a development data model that reads data from a Development Schema to a production data model that reads data from a Production Schema without actually creating the data model from scratch?
Details: We're about to make our initial release of Sisense embedded dashboards. We have a Production and Development Environment in Sisense and we're quite happy to be able to migrate dashboards and data models from one env to another seamlessly. However, here is the problem. We have a very complex data model and we don't want to recreate it from scratch every time we release a new version of the dashboards. In order to not impact the Production Dashboards while working on future versions, our Production Data Model is connected to a Production Schema in Snowflake while our Development Data Model is connected to a Development Schema in Snowflake. When we migrate DEV Dashboards and Data Models to PROD environment on Sisense, everything is good except the DATA SOURCE for our DEV Data Model. It still points to DEV Schema in Snowflake and there is no way to change the schema even though the underlying table names are same in both schemas. And again, we don't want to create the data models from scratch for Production Environment.
Has anyone find a solution for this? Thanks!
A simple way to do so is:
1. Export your data model
2. Edit the smodel JSON file and update the "connection" section with the correct schema name