Process Hub · Connections and lookup sources

How to configure and refresh process lookups

Stage approved lookup data and verify that process fields can use it.

On this page

Before you start

  • Configure and test the profile runtime SQL target and Lookup Lakehouse first. Have the required connection/data-management permissions and know the intended source table/columns.

Follow these steps

  1. Open Settings → Process Hub → Lookups and select Add lookup.
  2. Choose the Source table and required columns. Give it a clear Lookup name and review the runtime-table information before saving.
  3. Save the lookup definition, then use its available sync/refresh action and inspect Status, Last sync and row results.
  4. Open Lookup automation for recurring refreshes. Enable scheduled sync and set frequency, start time and Time zone; save the settings.
  5. If a Fabric pipeline must signal completion, enable Fabric API trigger and save. Give the one-time credential and receiver instructions securely to the integration owner; do not expose them to process users.
  6. Configure the process field to use the intended lookup and test its allowed values/filters in a deployed runtime. Source data changes appear after a successful refresh.

What you should see

The lookup’s selected data is available in runtime and has an explicit refresh plan.

If something goes wrong

Storage required appears

Return to Fabric setup and configure/test both required sources.

New values are missing

Review Recent syncs, source table/column selection and field filters. A pending/failed sync has not refreshed the runtime data.

You are considering Remove

Lookup removal can permanently remove its runtime table and sync history. Review dependent fields/processes with the data owner before any deletion.

Need a hand?

Contact your organisation’s Emplyr administrator using your usual internal support channel.

How to ask for help