Synchronization in Protect

Important 

In Collibra 2024.05, we launched a new user interface (UI) for Collibra Data Intelligence Platform! You can learn more about this latest UI in the UI overview.

Use the following options to see the documentation in the latest UI or in the previous, classic UI:

When you create data protection standards and data access rules, Protect automatically synchronizes them with the databases of the data sources at regular intervals. This synchronization (sync) runs in the background on a configured frequency. By default, the frequency is every 60 minutes. However, the frequency can be changed via the Protect scheduler fixed delay setting in Collibra Console.

Tip The Protect scheduler fixed delay setting is also available on the Services Configuration tab in Collibra. If the Services Configuration tab isn't shown to you, you can create a support ticket asking the following JVM Parameter to be added to your Collibra Infrastructure Configuration: -DPROTECT_SYNC_SCHEDULER_DELAY=PT60M. After the parameter is added, restart Collibra to synchronize the Protect policies with the data sources.

Sync processes

The sync includes the following processes:

  • Aggregation of all data protection standards and data access rules with a computation of the following:

    • Which columns need to be masked for which groups.
    • Which tables need to have a row filter.
    • Which tables and columns need to be granted access.

  • On the databases of the data sources such as Snowflake:

    • Creation and application of masking.
    • Creation and application of row filters.
    • Granting of access to groups on tables and columns (depending on the underlying database).

Sync statuses

The following table describes the statuses that may be shown in the Synchronization Status column on the Data Protection Standard or Data Access Rule tab.

Sync status Description
Draft Draft of the standard or rule is created.
Pending Standard or rule is created (published), and the sync has begun.
Active Sync is complete, and the standard or rule is enforced in the data source.
Failed

Sync has failed, and the standard or rule isn't enforced in the data source.

Tip 
Delete Pending Standard or rule will be deleted during the next sync. This sync status is shown when you delete an active standard or rule.
Not Deleted Standard or rule couldn't be deleted.

Tip For more information about the error, click next to the status.
Tip 
  • Protect periodically synchronizes with your data sources to update the status of standards and rules in Collibra. However, if the sync status is Failed, it remains in that status and does not automatically update, even after the underlying issue is resolved.
  • To view the status of a standard or rule in the data source, go to the database of the data source.