Working with Build to Destination

Select Build Destination

You must select a destination for the build.

  1. In Sisense, in the Data tab, click Build Destination. The Build Data Model To window displays.

    Note:

    The default selection is Elasticube, which builds to MonetDB.

  2. In the Destination Type drop-down list, select either Snowflake or Redshift.
  3. Enter a database name and schema, and click Apply.

Select Build Behavior for B2D

Build behavior for any table is Replace, by default. After the first full build, you can change the build behavior for a table as required. For B2D, the build behaviors, Incremental and Upsert, are in addition to the other build types that are relevant also for Elasticubes.

  1. In the Data Model, click the table, click the 3 buttons and select Build Behavior.
  2. Select a build type:
    • Incremental - Inserts new data only, based on a specific column. Each build inserts only the rows added since the last build:
      • New data defined by: Select a specific integer or date column used to determine whether to accumulate data at the time of the build
    • Update Insert (Upsert) - Update else Insert. Inserts new data and updates existing data, based on a unique key:
      • New data defined by: Select a specific integer or date column used to determine whether to accumulate data at the time of the build
      • Insert/Update defined by (Unique Key): Adds new rows to the table for data that doesn't already exist based on a unique key
  3. Click Apply.

See Defining ElastiCube Build Settings for other build types.

Adding a Custom Table or Custom Column for B2D

When building to destination, Sisense SQL is the default dialect, which is the same as an ElastiCube build:

  • You can change the default dialect and select the destination database dialect.
  • For a custom table, you can change the dialect to the destination database dialect only after a full build has run at least once. See Adding Custom Tables for more information.
  • For a custom column:
    • You must set an update sql for the column. This can be done before a full build.
    • Data type is string, by default. You can change the data type in the model after creating a custom column. See Adding a Custom Column for more information.