Canvas enables you to export the configured reports in JSON and SQL formats. You can use this feature to promote reports configuration from one environment to another, e.g. development to testing servers. Once you export the reports configuration in JSON format from source environment (e.g. development), you can then inject using the Import feature in Sigma Studio on the target environment (e.g. testing). If you have exported in SQL format from the source environment, you must execute the exported SQLs on the DB in the target environment.
It is essential that the appropriate connection, data source and data source aggregators used for the exported (downloaded) reports, should also be exported in the JSON format, so that the entire sets of configurations applied for the report could be used as individual JSON structures. Even for exporting the reports in the SQL format, t is essential that the appropriate connection, data source and data source aggregators used for the exported (downloaded) reports, should also be exported in the SQL format, so that the entire sets of configurations applied for the report could be used as individual SQL statements.
Perform the following to export the report configuration:
...