Warning Jobserver and all related Jobserver integrations are end of life starting October, 2024, with the exception of Public Sector customers using GovCloud or on-prem environments.
For information on registering a data source via Edge, go to Registering and synchronizing a data source via Edge.
You can refresh a schema manually, but you can also create a schedule to refresh a schema on a regular basis.
You can only create a refresh schedule for schemas of databases that are registered as a data source, not from CSV or Excel files.
Tip You can schedule the refresh during the data source registration process or afterwards via the Schema asset.
- To enable a scheduled schema refresh, you have to save the credentials in the configuration of a data source registration.
- The refresh schedule uses Quartz Cron expressions.
- If you use the schema for Tableau stitching, you have to restitch after each schema refresh to make sure that all relations are up-to-date.
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:
Prerequisites
- You have registered a data source.
- You have a global role with the Catalog global permission, for example, Catalog Author.
- You have a role with the following resource permissions on the community:
- Asset: add
- Attribute: add
- Domain: add
- Attachment: add
Note These permissions are always necessary when registering a data source.
Schedule the refresh during the data source registration process
You can create the refresh schedule when you register a data source.
When you register a Snowflake data source in Collibra Data Intelligence Platform, you can create a refresh schedule by selecting Schedule data refresh. You can then enter the CRON pattern 0 0 12?*WED to refresh every Wednesday at 12:00:00 PM.
Schedule the refresh via the Schema asset
You can create the refresh schedule when you refresh the schema of a registered data source via the Schema asset.
- Open the Schema asset.
-
On the main toolbar, click
, and then click
Catalog.
The Catalog Home opens. - In the submenu, click Data Dictionary and select the All Schemas view.
- Click the schema that you want to refresh.
Tip You can also use the Collibra Data Intelligence Platform search function to look up your schema.
-
On the main toolbar, click
- In the view bar, to the right, click Actions → Refresh.
The Refresh Schema dialog box appears.Tip If Catalog experience is disabled, the More menu is shown instead of Actions.
- In the Login information section, select Store credentials and enter the username and password you use to access your data source.
Your credentials are used to automatically connect to your data source and refresh the metadata in Collibra Data Intelligence Platform. - Select Schedule data refresh.
- Enter the required information.
Option Description Cron pattern
Cron Expression
Schedule of the data refresh as a Quartz Cron pattern.
Warning If you create an invalid cron pattern, Collibra Data Intelligence Platform stops responding.
Time Zone The time zone of the database. - Click Save.