Reltio Google BigQuery (GBQ) Connector
Learn about the different ways that you can leverage Reltio connected data to gain insights into your business processes and initiatives.
Are you a data scientist or business analyst who is in charge of managing and analyzing data in your organization’s BigQuery data platform? If you’d like a better way to report accurate insights and critical updates quickly and efficiently, then this is the topic for you!
The Reltio GBQ connector delivers clean, merged, and validated profile data to your BigQuery platform, so that you always have accurate data to inform your analytical and reporting decisions. Ensure that your GBQ tables and views are always in sync with your Reltio data model with a seamless Reltio-managed onboarding experience and an automated Reltio data event streaming process. Instantly convert Reltio data updates into GBQ tables and views in near real-time using Reltio’s data pipeline. Reduce developmental costs and enhance operational efficiency by eliminating the need for manual data exports and custom programming when moving data into the BigQuery data cloud with the GBQ connector.
Key features and benefits
Following are the key features of the Reltio GBQ connector and the benefits associated with each feature:
Enjoy the benefits of low Code/no code with Reltio’s data pipeline
During implementation, you're responsible for bringing your GBQ project, dataset name, and allowing Reltio permissions to write data into your GBQ environment. From there, you only need to follow Reltio-provided instructions and code to finish the setup to connect data to your GBQ. After implementation, Reltio routinely pushes data to your GBQ environment, so you don't have to pull any data or schedule any jobs from Reltio as Reltio manages the data pipeline, schema, and format moving forward.
Get a complete view of your data with the support of Reltio data types
Entity, relation, interaction, match, and merge tables are provided, which you can query at any time. A single entity can be tracked across tables to understand relationships and transactions with other entities. Certain attributes and source data can be identified within a single entity profile. To enhance mastering of data, potential matches and historical merges of entities can be analyzed to refine and improve processes upstream in the Reltio platform. Further, all data represented in these tables reflect the deduplication, enrichment, and standardization functions that occur in the Reltio platform to represent trusted and connected data in any type of analytical model, calculation, report, or visualization allowed within your GBQ environment. Lastly, all data in these tables can be combined with other sources of data in GBQ to represent a single source of truth factor within your analytics and data science applications.
Analyze brand-new Reltio data in near real-time
Several data-related activities can occur within the Reltio platform at any given time. You may update the policy date after a customer renewal event, delete a relation between two entities after a merge has taken place, or add a new data source for Reltio to cleanse. Regardless of any activity that occurs in the Reltio platform, the Reltio GBQ connector will capture and display the latest version of a data update and display the most recent object, like an entity or relation in the customer’s GBQ environment that would be available to query. Further, any data update that would occur upstream in the Reltio platform would be reflected in your GBQ environment in a matter of minutes by applying both Reltio’s and Google Cloud Platform's (GCP) streaming technology to push events in near-real time, so that you'll always have access to the latest data for producing insights.
Build self-serve reports
Reltio integrates analytics reporting into Google BigQuery's native Business Intelligence (BI) tool and LookerStudio. Get started quickly with our reporting template to learn how to use your GBQ data provided by Reltio. This is a quick-start guide that helps you visualize your data and gain insights. Build reports with your own data to provide analytical information on your own initiatives for further consumption.
Retain your legacy views and structures
It can have a maximum of 10000 columns.
It transforms invalid characters in attribute names to underscore (_) characters.
For next steps, see topic Configure the Reltio GBQ Connector to get started with using the Reltio GBQ connector.