In version 13.0, distributed Data Sources and Datamarts have been introduced. This article helps you make the required configuration settings to switch to the distributed database.
To configure a Datamart or Data Source as distributed, follow these steps:
In the Unity user interface, navigate to Analytics > Data Manager > Data Sources or Datamarts.
Open a Data Source or Datamart and click the Import & Export button.
In the JSON definition, locate the desired distribution field and
Make sure it is defined as a key –
"key": true,Set the
"distributionKey"property to true.
Click Apply.
When a Datamart source, i.e., a Data Source, is distributed then the Datamart (on deployment and rebuild if previously already deployed) will be automatically distributed on the same key.
New Data Sources / Datamarts
When a Data Source or Datamart has not previously been deployed, i.e., there is no corresponding table in the database, then a distributed table is created for it on the first deploy. In new implementations, it is recommended to choose the distribution key and configure it in the necessary Data Sources and Datamarts from the beginning.
Existing Data Sources / Datamarts
When a table already exists in the database, it is not automatically converted on deployment to a distributed table after the Data Source / Datamart is reconfigured to have a distributed key. Distributed tables will normally be used to hold large amount of data and altering a table on the fly in a UI transaction would very quickly time out.
Instead, the table is rebuilt as a new and distributed table when the IndexMaintenance job for the Data Source / Datamart is run in non-incremental mode.