Exporting and Importing Data Models
  • 08 May 2022
  • 1 Minute to read
  • Dark
    Light

Exporting and Importing Data Models

  • Dark
    Light

You can export and import your ElastiCube data and live data models into Sisense. Models can be exported as .smodel files. The .smodel file contains the design of your model’s schema and its connection settings to its sources.

Note:

All .smodel files created in earlier versions of Sisense are compatible with later versions. However, you can't import .smodel files from later versions of Sisense into earlier versions.

For Linux deployments, you can select to export a .sdata file. The .sdata file contains the design of your model’s schema, connection settings to its sources, and the data itself.

Exporting a Model in Linux

You might want to export a model to use it as a backup, as a base for another ElastiCube, or to load it onto a different Sisense server.

To export a model:

  1. Open the Data page.

  2. For the relevant ElastiCube, select > Export Model .

    8-6export-model-menuthumb0300.png

  3. Select whether to export only the model schema (A) or the model schema and the data (B).

    8-6export-model-datathumb0300.png

  4. Click Export .

    You're prompted to download a file:

    • If you're exporting the model only (A), you'll be prompted to download a .smodel file
    • If you're exporting the model and data (B), you'll be prompted to download a .sdata file
Notes:
  • Rebuilding the model from a .smodel file could be time-consuming.

  • When exporting a .sdata file, keep in mind that it might be very big. You might need to be able to transfer a large volume of data and have the disk space to support it.

Importing a Model in Linux

To import a model:

  1. Open the Data page.

  2. Click Import Model .

    8-6importmodelthumb0300.png

  3. Drag a .smodel file (model only) or .sdata file (model and data) to the Import dialog box.

    OR

    Click Browse. Navigate to the relevant .smodel or .sdata file and select it.

  4. If a model with the same name already exists, either rename the model or overwrite the existing model with the one you're importing.

    8-6import-model-overwrite-namethumb0300.png

    The schema is displayed and the model is added to the Data page. Build the model so that you can work with it in your dashboard. If you imported a .sdata file, you can view the data immediately, without needing to perform a build.


Was this article helpful?