...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
LEARN MORE: For more information on Citus, click here. |
Using Distributed Datamart
To achieve optimal performance from a distributed Data Mart (DM), it is essential to ensure that the field serving as the distribution key is consistently defined as the distribution key in the corresponding Data Source (DS) from which the data is derived.
...
In addition, though optional, unless the Product DS is trivially small, it is recommended to define the productId key field there also as a distribution key. This schema ensures the greatest benefit when loading and querying the DM.
How configure a DS or DM to be distributed?
In the user interface (UI), perform the following:
...
When a Data Mart source (i.e., a Data Source) is distributed, the Data Mart will automatically be distributed on the same key during deployment, and if it was previously deployed it will need to be rebuilt.
New Data Source or Data Mart
When a DS/DM has not previously been deployed, i.e. no table for it exists in the PA DB, 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 a necessary DSs and DMs from the start
Existing Data Source or Data Mart
When a table is already present in the PA DB, it does not undergo automatic conversion to a distributed table upon deployment, even if the Data Source (DS) or Data Mart (DM) is reconfigured to have a distributed key.
...