Unify and manage your data

Data structure for Reltio Data Sharing with Databricks

Learn more about the schema and streaming tables shared with your Databricks workspace.

Reltio Data Sharing with Databricks provides your Databricks workspace with read-only access to Reltio-managed Delta tables through Open Sharing.

The shared schema contains streaming tables for entities, relations, interactions, matches, merges, links, workflows, and activities. You can access these tables from Databricks SQL, notebooks, dashboards, and AI and machine learning workloads.

Shared schema

After the data share is received, a Databricks user creates a catalog from the share or mounts the share to an existing catalog. The user chooses the catalog name.

Within the catalog, the shared Reltio tables are grouped in a schema named reltio_datashare_{datashareName}. The {datashareName} value is the name assigned to your data share in Reltio.

Reltio provides read-only access to every table in the shared schema. These tables include type-specific landing and streaming tables for entities, relations, and interactions, as well as fixed-name landing and streaming tables for matches, merges, links, workflows, and activities.

Objects in the shared schema

The shared schema organizes each Reltio data type into its corresponding landing and streaming tables.

Data typeLanding tableStreaming table
Entityentity_{entityType}_landingTableentity_{entityType}
Relationrelation_{relationshipType}_landingTablerelation_{relationshipType}
Interactioninteraction_{interactionType}_landingTableinteraction_{interactionType}
Matchesmatches_landingTablematches
Mergesmerges_landingTablemerges
Linkslinks_landingTablelinks
Workflowsworkflow_landingTableworkflows
ActivitiesNot applicableactivities

Reltio updates each streaming table as Data Sharing processes the corresponding events. Landing tables are visible in the shared schema but are not intended for downstream analysis. Best practices for Reltio Data Sharing with Databricks explains which tables to query.

Schema representation

The setup of your data share determines the schema representation:

  • If the data share is setup to share only operational values, Reltio uses the simplified schema.

  • If the data share is setup to share both operational and non-operational values, Reltio uses the hierarchical schema.