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.
Note: This feature is intended for very large Data Sources and Datamarts and it is enabled upon request by a support ticket.
To configure a Datamart or Data Source as distributed, follow these steps:
...
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.
Distribution Key Requirements
Key Field Designation – The distribution key should be a key field of the DS/DM. Typically, either the product ID or customer ID field is chosen as the distribution key.
Consistency Across DS and DM – To maximize performance, the field used as the distribution key in the DM must also be defined as the distribution key in the DS from which it is sourced.
Recommendation for Product DS – Unless the Product DS is very small, it is recommended to define the productId key field as a distribution key. This ensures optimal performance during data loading and querying.
Existing Data Sources / Datamarts
...