Synchronization

Protect automatically synchronizes data protection standards and data access rules with the databases of the data source providers such as BigQuery and Snowflake at regular intervals. This synchronization runs in the background on a configured frequency. By default, the frequency is every 60 minutes. You can, however, change the frequency through the Protect scheduler fixed delay field on the Services Configuration tab in Collibra.

Services Configuration tab

Important If the Services Configuration tab is not shown to you, create a support ticket asking the following JVM Parameter 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 source providers.

The synchronization 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 source providers 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)