Configure Reltio Zero Copy Interaction Integration from Databricks using APIs
Learn how to configure Reltio Zero Copy Interaction Integration by completing the required API tasks in sequence.
Configure the Databricks connection and mapping required for Reltio Zero Copy Interaction Integration from Databricks by completing the required API tasks in sequence. Create a Databricks connection, store service principal credentials, test the connection, and map a Databricks source object to a Reltio interaction type. After you complete these tasks, Reltio can query the mapped Databricks source and return matching interaction data for the related profile without copying that data into Reltio.
Prerequisites
- A Reltio role that allows you to manage data integrations, such as
ROLE_ADMINorPUBLIC. - A running Databricks SQL Warehouse.
- A Databricks service principal with an OAuth client ID and client secret.
- Databricks permissions that allow the service principal to access integration objects, including:
-
CAN USEon the SQL Warehouse. -
USE CATALOGon the target catalog. -
USE SCHEMAon the target schema. -
SELECTon each target table or view.
-
- An existing Reltio interaction type to use in the mapping.
- The Databricks workspace URL, warehouse ID, and shared catalog name for the source data.
Configure Zero Copy integration with Databricks
- Create a Databricks connection in Reltio: Define the Databricks workspace, SQL Warehouse, shared catalog, connection properties, and authentication type for the integration.
- Store Databricks OAuth credentials in Reltio: Store the service principal client ID and client secret that Reltio uses to request and refresh Databricks access tokens automatically.
- Test the Databricks connection in Reltio: Verify that Reltio can connect to the Databricks SQL Warehouse before you create the interaction mapping.
- Map a Databricks source object to a Reltio interaction type: Define the Databricks source object, returned attributes, interaction type, and member mappings that link Databricks rows to Reltio entities.
Result
After you complete these tasks, Reltio queries the mapped Databricks source and returns matching external interaction data for the related profile without copying that data into Reltio. The connection, credentials, connection test, and mapping together complete the API setup required to make the mapped Databricks source available in Intelligent 360.