Materialized Lake Views - Update Mlv Execution Definition

Service:: Lakehouse

API Version:: v1

Updates the specified materialized lake views execution definition.
Only the fields provided in the request body are updated; omitted fields retain their existing values.

Permissions

The caller must have contributor or higher workspace role.

Required Delegated Scopes

Lakehouse.ReadWrite.All or Item.ReadWrite.All

Microsoft Entra supported identities

This API supports the Microsoft identities listed in this section.

Identity	Support
User	Yes
Service principal and Managed identities	Yes

Interface

PATCH https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/lakehouses/{lakehouseId}/mlvexecutiondefinitions/{mlvExecutionDefinitionId}

URI Parameters

Name	In	Required	Type	Description
lakehouseId	path	True	string (uuid)	The lakehouse ID.
mlvExecutionDefinitionId	path	True	string (uuid)	The materialized lake views execution definition ID.
workspaceId	path	True	string (uuid)	The workspace ID.

Request Body

Name	Type	Description
currentLakehouseExecutionContext	CurrentLakehouseExecutionContext: CurrentLakehouseExecutionContextAll CurrentLakehouseExecutionContextSelected	The current lakehouse execution context for the materialized lake views execution definition.
description	string	A short description of the materialized lake views execution definition.
displayName	string	The materialized lake views execution definition display name.
extendedLineageExecutionContext	ExtendedLineageExecutionContextRequest: ExtendedLineageExecutionContextRequestAll ExtendedLineageExecutionContextRequestSelected	The extended lineage execution context for the materialized lake views execution definition.
settings	MaterializedLakeViewExecutionDefinitionSettingsRequest	The materialized lake views execution definition settings.

Responses

Name Type Description

200 OK

Name	Type	Description
200 OK	MaterializedLakeViewExecutionDefinition	Request completed successfully.
429 Too Many Requests	ErrorResponse	The service rate limit was exceeded. The server returns a `Retry-After` header indicating, in seconds, how long the client must wait before sending additional requests. Headers Retry-After: integer
Other Status Codes	ErrorResponse	Common error codes: InvalidRequest - Request parameters are invalid or not in a supported format InsufficientPrivileges - The caller does not have sufficient permissions ItemNotFound - Requested item ID not found ConflictingRequest - A conflicting update was detected

MaterializedLakeViewExecutionDefinition

Request completed successfully.

429 Too Many Requests

ErrorResponse

The service rate limit was exceeded. The server returns a Retry-After header indicating, in seconds, how long the client must wait before sending additional requests.

Headers

Retry-After: integer

Other Status Codes

ErrorResponse

Common error codes:

InvalidRequest - Request parameters are invalid or not in a supported format
InsufficientPrivileges - The caller does not have sufficient permissions
ItemNotFound - Requested item ID not found
ConflictingRequest - A conflicting update was detected

Examples

Update a materialized lake views execution definition example

Sample request

HTTP

PATCH https://api.fabric.microsoft.com/v1/workspaces/a0a0a0a0-bbbb-cccc-dddd-e1e1e1e1e1e1/lakehouses/dddddddd-9999-0000-1111-eeeeeeeeeeee/mlvexecutiondefinitions/bbbbbbbb-1111-2222-3333-cccccccccccc

{
  "displayName": "Updated Gold Chain – Sales",
  "settings": {
    "refreshMode": "Full"
  },
  "currentLakehouseExecutionContext": {
    "mode": "All"
  },
  "extendedLineageExecutionContext": {
    "mode": "Selected",
    "selectedLakehouses": [
      {
        "referenceType": "ById",
        "itemId": "cccccccc-4444-5555-6666-dddddddddddd",
        "workspaceId": "11111111-2222-3333-4444-555555555555"
      }
    ]
  }
}

Sample response

Status code:: 200

{
  "id": "bbbbbbbb-1111-2222-3333-cccccccccccc",
  "displayName": "Updated Gold Chain – Sales",
  "description": "Weekly report on Gold chain",
  "settings": {
    "environment": {
      "referenceType": "ById",
      "itemId": "aaaaaaaa-1111-2222-3333-bbbbbbbbbbbb",
      "workspaceId": "11111111-2222-3333-4444-555555555555"
    },
    "refreshMode": "Full"
  },
  "currentLakehouseExecutionContext": {
    "mode": "All"
  },
  "extendedLineageExecutionContext": {
    "mode": "Selected",
    "selectedLakehouses": [
      {
        "referenceType": "ById",
        "itemId": "cccccccc-4444-5555-6666-dddddddddddd",
        "workspaceId": "11111111-2222-3333-4444-555555555555"
      }
    ]
  }
}

Definitions

Name	Description
CurrentLakehouseExecutionContextAll	Current lakehouse execution context where all materialized lake views are included.
CurrentLakehouseExecutionContextSelected	Current lakehouse execution context where only selected materialized lake views are included.
ErrorRelatedResource	The error related resource details object.
ErrorResponse	The error response.
ErrorResponseDetails	The error response details.
ExecutionContextMode	The execution context mode. Additional `ExecutionContextMode` types may be added over time.
ExtendedLineageExecutionContextRequestAll	Extended lineage execution context where all lakehouses are included.
ExtendedLineageExecutionContextRequestSelected	Extended lineage execution context where only selected lakehouses are included.
ExtendedLineageExecutionContextResponseAll	Extended lineage execution context where all lakehouses are included (response).
ExtendedLineageExecutionContextResponseSelected	Extended lineage execution context where only selected lakehouses are included (response).
ItemReferenceById	An item reference by ID object.
ItemReferenceByVariable	An item reference by variable.
ItemReferenceType	The item reference type. Additional `ItemReferenceType` types may be added over time.
MaterializedLakeViewExecutionDefinition	A materialized lake views execution definition object.
MaterializedLakeViewExecutionDefinitionSettingsRequest	The materialized lake views execution definition settings.
MaterializedLakeViewExecutionDefinitionSettingsResponse	The materialized lake views execution definition settings (response).
RefreshMode	The refresh mode for the execution definition. Additional `RefreshMode` types may be added over time.
UpdateMaterializedLakeViewExecutionDefinitionRequest	Update materialized lake views execution definition request payload. Only the fields provided are updated; omitted fields retain their existing values.

CurrentLakehouseExecutionContextAll

Object

Current lakehouse execution context where all materialized lake views are included.

Name	Type	Description
mode	string: All	The execution context mode for the current lakehouse.

CurrentLakehouseExecutionContextSelected

Object

Current lakehouse execution context where only selected materialized lake views are included.

Name	Type	Description
mode	string: Selected	The execution context mode for the current lakehouse.
selectedMlvs	string[]	The list of fully qualified names of materialized lake views from the current lakehouse to be refreshed.

ErrorRelatedResource

Object

The error related resource details object.

Name	Type	Description
resourceId	string	The resource ID that's involved in the error.
resourceType	string	The type of the resource that's involved in the error.

ErrorResponse

Object

The error response.

Name	Type	Description
errorCode	string	A specific identifier that provides information about an error condition, allowing for standardized communication between our service and its users.
isRetriable	boolean	When true, the request can be retried. Use the `Retry-After` response header to determine the delay, if available.
message	string	A human readable representation of the error.
moreDetails	ErrorResponseDetails[]	List of additional error details.
relatedResource	ErrorRelatedResource	The error related resource details.
requestId	string (uuid)	ID of the request associated with the error.

ErrorResponseDetails

Object

The error response details.

Name	Type	Description
errorCode	string	A specific identifier that provides information about an error condition, allowing for standardized communication between our service and its users.
message	string	A human readable representation of the error.
relatedResource	ErrorRelatedResource	The error related resource details.

ExecutionContextMode

Enumeration

The execution context mode. Additional ExecutionContextMode types may be added over time.

Value	Description
All	All items are included in the execution boundary.
Selected	Only selected items are included in the execution boundary.

ExtendedLineageExecutionContextRequestAll

Object

Extended lineage execution context where all lakehouses are included.

Name	Type	Description
mode	string: All	The execution context mode for extended lineage.

ExtendedLineageExecutionContextRequestSelected

Object

Extended lineage execution context where only selected lakehouses are included.

Name	Type	Description
mode	string: Selected	The execution context mode for extended lineage.
selectedLakehouses	ItemReferenceById[]	The list of lakehouses to be included in refresh.

ExtendedLineageExecutionContextResponseAll

Object

Extended lineage execution context where all lakehouses are included (response).

Name	Type	Description
mode	string: All	The execution context mode for extended lineage.

ExtendedLineageExecutionContextResponseSelected

Object

Extended lineage execution context where only selected lakehouses are included (response).

Name	Type	Description
mode	string: Selected	The execution context mode for extended lineage.
selectedLakehouses	ItemReference[]: ItemReferenceById[] ItemReferenceByVariable[]	The list of lakehouses to be included in refresh.

ItemReferenceById

Object

An item reference by ID object.

Name	Type	Description
itemId	string (uuid)	The ID of the item.
referenceType	string: ById	The item reference type.
workspaceId	string (uuid)	The workspace ID of the item.

ItemReferenceByVariable

Object

An item reference by variable.

Name	Type	Description
referenceType	string: ByVariable	The item reference type.
variableReference	string	A variable reference string that specifies the Variable Library and the variable name inside it. Format: `$(/**/_VarLibrary_/_VarName_)` for a Variable Library named VarLibrary and a variable named VarName.

ItemReferenceType

Enumeration

The item reference type. Additional ItemReferenceType types may be added over time.

Value	Description
ById	The item is referenced by its ID.
ByVariable	The item is referenced by a variable.

MaterializedLakeViewExecutionDefinition

Object

A materialized lake views execution definition object.

Name	Type	Description
currentLakehouseExecutionContext	CurrentLakehouseExecutionContext: CurrentLakehouseExecutionContextAll CurrentLakehouseExecutionContextSelected	The current lakehouse execution context for the materialized lake views execution definition.
description	string	A short description of the materialized lake views execution definition.
displayName	string	The materialized lake views execution definition display name.
extendedLineageExecutionContext	ExtendedLineageExecutionContextResponse: ExtendedLineageExecutionContextResponseAll ExtendedLineageExecutionContextResponseSelected	The extended lineage execution context for the materialized lake views execution definition.
id	string (uuid)	The materialized lake views execution definition ID.
settings	MaterializedLakeViewExecutionDefinitionSettingsResponse	The materialized lake views execution definition settings.

MaterializedLakeViewExecutionDefinitionSettingsRequest

Object

The materialized lake views execution definition settings.

Name	Type	Description
environment	ItemReferenceById	The Spark environment reference to be used with the materialized lake views execution definition.
refreshMode	RefreshMode	The refresh mode setting to be used with the materialized lake views execution definition. Defaults to `Optimal` if not specified.

MaterializedLakeViewExecutionDefinitionSettingsResponse

Object

The materialized lake views execution definition settings (response).

Name	Type	Description
environment	ItemReference: ItemReferenceById ItemReferenceByVariable	The Spark environment reference to be used with the materialized lake views execution definition.
refreshMode	RefreshMode	The refresh mode setting to be used with the materialized lake views execution definition. Defaults to `Optimal` if not specified.

RefreshMode

Enumeration

The refresh mode for the execution definition. Additional RefreshMode types may be added over time.

Value	Description
Optimal	This mode chooses the best strategy to maximize performance from among incremental, full, or no recompute while refreshing each materialized lake view.
Full	This mode enforces the full recompute for materialized lake views being refreshed.

UpdateMaterializedLakeViewExecutionDefinitionRequest

Object

Update materialized lake views execution definition request payload. Only the fields provided are updated; omitted fields retain their existing values.

Name	Type	Description
currentLakehouseExecutionContext	CurrentLakehouseExecutionContext: CurrentLakehouseExecutionContextAll CurrentLakehouseExecutionContextSelected	The current lakehouse execution context for the materialized lake views execution definition.
description	string	A short description of the materialized lake views execution definition.
displayName	string	The materialized lake views execution definition display name.
extendedLineageExecutionContext	ExtendedLineageExecutionContextRequest: ExtendedLineageExecutionContextRequestAll ExtendedLineageExecutionContextRequestSelected	The extended lineage execution context for the materialized lake views execution definition.
settings	MaterializedLakeViewExecutionDefinitionSettingsRequest	The materialized lake views execution definition settings.