Change sync schedule or start sync

In Data Access, the default sync schedule for a data source is daily at midnight. You can change the global sync schedule or set a custom sync schedule for specific entities.

You can also manually start a sync for a data source at any time, without waiting for the next scheduled sync. By default, this action pulls all access controls, groups, accounts, and data objects from the underlying data source into Data Access, and pushes all access controls from Data Access to the data source. You can, however, choose which sync tasks to run.

Prerequisites

You are the data source owner.

Steps: Change sync schedule

  1. On the Data Access landing page, click RESOURCES > Data Sources.
  2. Click the data source.
    The data source page opens.
  3. In the upper-right corner of the header, click > Configure.
    The Configuration page opens.
  4. To change the global sync schedule:
    1. In the Global schedule field, click the current value.
      The Global schedule dialog box appears.
    2. Select the sync frequency and time.
    3. Click Apply and then Save.
  5. To change the sync schedule for a specific entity:
    1. In the sync schedule field for the entity, click the current value.
      The sync schedule dialog box appears.
    2. Switch off the Inherit general sync schedule option and specify the sync frequency, day of the week (if applicable), and sync time.
      Tip If you never want the entity to be synchronized, switch on the Never sync option.
    3. Click Apply and then Save.

Steps: Manually start sync

  1. On the Data Access landing page, click RESOURCES > Data Sources.
  2. Click the data source.
    The data source page opens.
  3. Click Sync now.
    The Sync [data source name] dialog box appears.
  4. Clear the sync tasks you do not want to run and click Start sync.
    A confirmation message appears.

Sync progress

You can use the Jobs tab on the data source page to check the progress of a sync job. The Jobs tab shows a list of all sync jobs associated with the data source. For each sync job, you can see which entities were processed, time stamps when the job started and completed, status of the job, duration of the job, and warnings. The list of warnings contains potential issues that were found during the sync.

It is normal to see warnings indicating that certain objects could not be found, if you explicitly excluded them using regular expressions during the data source configuration. These warnings appear because Data Access has pulled the roles that provide access to those excluded objects.

After the sync is completed, the Data tab on the data source page shows the imported hierarchy, for example, databases, schemas, tables, views, and tags.

Related topics

How data sources sync