Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
Refresh Materialized Lake View activity in Fabric Data Factory pipelines
The Refresh Materialized Lake View activity refreshes a materialized lake view as part of a Fabric pipeline. Materialized lake views are precomputed, cached result sets stored in a Lakehouse that speed up downstream queries. Use this activity to keep cached results in sync with your source data after ingestion, transformation, or maintenance operations.
Use the Refresh Materialized Lake View activity when you want to:
- Refresh a materialized lake view on demand or on a schedule.
- Refresh views after upstream activities like Copy, Notebook, or Lakehouse Maintenance.
- Include lake view refreshes in end-to-end pipeline orchestration.
Prerequisites
Before you start, make sure you have:
- A Microsoft Fabric workspace
- A Lakehouse in the target workspace
- A materialized lake view in the Lakehouse
- Permission to access the workspace and the Lakehouse
- A pipeline with access to the Lakehouse through the selected connection
Add the refresh materialized lake view activity to a pipeline
Create a new pipeline or open an existing one.
Search for Refresh Materialized Lake View in the Activities pane and select it to add it to the canvas.
👁 Screenshot of the pipeline Activities pane with the Refresh Materialized Lake View activity highlighted.
Select the activity on the canvas.
👁 Screenshot of the Refresh Materialized Lake View activity on the pipeline canvas.
On the General tab, configure the activity name and other general settings. For guidance, see General settings.
Configure refresh materialized lake view settings
On the Settings tab:
- Select an existing Connection from the dropdown, or create a new one.
- Select the Workspace that contains the Lakehouse.
- Select the Lakehouse that contains the materialized lake view you want to refresh.
👁 Screenshot of the Refresh Materialized Lake View activity settings.
Common scenarios
Refresh after ingestion
Add the Refresh Materialized Lake View activity after a Copy activity so that your analytics reflect the latest data.
Scheduled refresh
Run the activity on a schedule to keep lake views current without manual steps.
👁 Screenshot of a scheduled pipeline that includes a Refresh Materialized Lake View activity.
End-to-end orchestration
Include the activity in a broader pipeline that ingests, transforms, and publishes data. Place the refresh step after upstream data operations so materialized lake views always reflect the most recent data.
Known limitations
The Refresh Materialized Lake View activity doesn't currently support service principal name (SPN) or workspace identity authentication. If you use SPN or workspace identity for automated or service-based access, you might encounter limitations when configuring or running this activity.
Related content
Feedback
Was this page helpful?