Trigger Refresh Jobs

This applies to: Visual Data Discovery

Symphony maintains data source metadata and, optionally, a cached result set of the data from the data store for each data source configuration you define. When you initially connect to your data store using a data source configuration, a sampling of the data is collected to determine:

  • Distinct values for all fields with ATTRIBUTE and NUMBER field types.
  • The minimum and maximum values for all fields with number or time data types for which Custom Ranges have not been defined.

Symphony administrators can define refresh jobs for this cached data. The following table identifies the types of refresh jobs that are currently supported, the triggers for the jobs, and the activities that occur when the job is run.

Refresh Type Trigger Activities
Source Refresh

An initial connection to a data source is saved. See Define a Visual Data Discovery Data Source Configuration.

 The Symphony cache is cleared and the minimum and maximum values for non-attribute fields and distinct values for attribute and number fields are refreshed.
Changes to the Source Creation Tab or Fields tab in the data source configuration are saved. See Edit a Data Source Configuration.
The scheduled refresh time (set on the Cache tab in the data source configuration) occurs. See Set Up a Data Source Refresh Job.
Field Refresh
  • To refresh the entire list of fields in a data source configuration, access the Cache tab and select the refresh () button for Manual Refresh in the table heading to trigger a manual refresh for all fields. This triggers a manual refresh of all the field data.
  • To refresh a specific field in a data source, access the Cache tab and select the Manual Refresh button () for the field you want to refresh. This triggers an immediate manual refresh for the selected field.
 The minimum and maximum for non-attribute fields and distinct values for attribute and number fields are refreshed.
After Cache Cleanup

When a user selects an available Cache Cleanup option from the Actions column for a data source on the Sources page. See Clear the Cache for a Data Source Configuration.

 The data is freshly loaded into the Symphony cache the next time it is requested from the data source.

If a Custom Range has been defined for a field, the minimum and maximum fields used in filters remain unchanged when you refresh source data. These fields are shown with cache actions disabled on the Cache tab.

When you add a new field to a data source, the scheduled refresh is not enabled for the new fields by default. Quickly enable scheduled refresh for all fields using the bulk update option in the Schedule Refresh menu on the Cache tab, or enable each field for scheduled refresh manually on the Cache tab.

The status of refresh jobs can be reviewed on the Console of Refreshing Jobs. See Review Refresh Jobs.