Unify and manage your data

Best practices for Reltio data sharing with Microsoft Fabric - essentials

Learn about recommended practices for using streaming tables in Reltio data sharing with Microsoft Fabric - essentials so that you can query the supported tables and avoid unsupported downstream usage.

Use data shares for analytics and data engineering workloads

Use data shares for downstream systems such as BI, reporting, and ML pipelines.

Query supported tables

Use the following tables to query data.

  • EXTERNAL_entity_<entity_type>_Shortcut

  • EXTERNAL_relation_<relation_type>_Shortcut

  • EXTERNAL_interaction_<interaction_type>_Shortcut

  • EXTERNAL_links_Shortcut

  • EXTERNAL_matches_Shortcut

  • EXTERNAL_merges_Shortcut

These tables use the hierarchical All Values schema, which includes all values available for each attribute.

Note:

Data synchronization is triggered every four hours. The time required for updates to become available in the shared tables depends on the volume of data to be processed and the processing duration.

Practices to avoid

Avoid using data shares for non-analytics downstream systems

Do not use data shares to build downstream systems for non-analytics use cases.