Accelerate the Value of Data

Validate Reltio event transfer to Azure cloud storage and Snowflake

Learn how to verify event transfers from Reltio to your Azure cloud storage and Snowflake.

Verify events are transferred between your Reltio tenant and cloud storage using any of these methods:
  • Reltio Hub

  • Reltio REST API

  • Reindex a record

Tip: We recommend you use the method that you are most familiar with or that is most appropriate for the tenant. For example, it might be more appropriate to create or edit records in a dev or test tenant, while you might reindex a single record on a production tenant.
To validate Reltio event transfer to Azure cloud storage:
  1. Initiate a Reltio event transfer in any of the following ways:
    • In the Hub Profile page, create or update a profile in your Reltio tenant. For more information, see topics Adding a Profile and Editing profiles.

      OR

    • Create or update a Reltio profile using either the Create Entities or the Partial overrides. For more information, see topics Create entities and Partial overrides.

      OR

    • Reindex a Reltio profile using the Tasks reindex data task. For more information, see topic Reindex Data Task.

      Important: In the API request body, include the entityURI of a single record, so only this single profile is reindexed. This is a test, so you don't want to reindex all of the data in your tenant.
  2. In the Microsoft Azure portal, view compressed Reltio data files that were created by the event transfer you initiated in the previous step:
    1. Search for and select Storage accounts.
    2. On the Storage accounts page, select the storage account you previously created in Create an Azure storage account.
    3. Select the Azure storage account container you previously created in Create an Azure storage account container.
    4. In the Overview page folders list, select the folder with the name of the Reltio tenant environment, then the name of the tenantId.
    5. Confirm that one or more Reltio GZ files appear in the list.
  3. In Snowflake, view Reltio data files that were created by the event transfer you initiated:
    1. In the Snowflake application worksheet area, create a new SQL worksheet.
    2. In the SQL worksheet, run this command:
      select * from "<database_name>"."<schema_name>"."entities";
      where:
    3. Confirm that one or more Reltio profiles appear in the results pane, where the URI corresponds to the entity you created, updated, or reindexed in step 1.
      Tip: If no results are shown for the entities staging table, it could indicate an issue with the object type processing tasks or streams in Snowflake. To troubleshoot this, work backwards and rerun the query against the landing data tables. If no results are shown for the landing tables, it could indicate an issue with the Snowpipe, external stage or the event notification integration.

      If you're not able to resolve the issue, contact Reltio Support for assistance. For more information, see topic

      Need some help?
You're now ready to synchronize all of your tenant data to Snowflake.