Microsoft Fabric Materialized Lake Views API
The MaterializedLakeViews API from Microsoft Fabric — 2 operation(s) for materializedlakeviews.
Work with this as data
Every API here is available over the APIs.io API and to AI agents over MCP.
MCP server
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
Tools for apis
7 MCP tools reach this
find_apisBrowse and filter every API in the catalog.get_api_artifactsOne API's artifacts, grouped by type.get_openapiThe primary OpenAPI for this API.find_similar_apisAPIs that look like this one.apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.resolveTurn a domain, URL or GitHub org into the provider it belongs to.find_cohortsEvery scored population of providers in the catalog.
Call it yourself
curl for this page
This API
curl "https://apis.io/api/v1/apis/microsoft-fabric:microsoft-fabric-materializedlakeviews-api"
All apis
curl "https://apis.io/api/v1/apis?limit=25"Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.
Get an API key
Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.
OpenAPI Specification
openapi: 3.2.0
info:
title: Microsoft Fabric Workload Items REST Materialized Lake…
version: v1
x-source: 'https://github.com/microsoft/fabric-rest-api-specs (bundled from openapi/_original/fabric-rest-api-specs: anomalyDetector/swagger.json, apacheAirflowJob/swagger.json, appBackend/swagger.json, azureDatabricksStorage/swagger.json, copyJob/swagger.json, cosmosDbDatabase/swagger.json, dashboard/swagger.json, dataAgent/swagger.json, dataBuildToolJob/swagger.json, dataPipeline/swagger.json, dataflow/swagger.json, datamart/swagger.json, deploymentPlan/swagger.json, digitalTwinBuilder/swagger.json, digitalTwinBuilderFlow/swagger.json, environment/swagger.json, eventSchemaSet/swagger.json, eventhouse/swagger.json, eventstream/swagger.json, graphModel/swagger.json, graphQLApi/swagger.json, graphQuerySet/swagger.json, kqlDashboard/swagger.json, kqlDatabase/swagger.json, kqlQueryset/swagger.json, lakehouse/swagger.json, map/swagger.json, mirroredAzureDatabricksCatalog/swagger.json, mirroredCatalog/swagger.json, mirroredDatabase/swagger.json, mirroredWarehouse/swagger.json, mlExperiment/swagger.json, mlModel/swagger.json, monitoring/swagger.json, mountedDataFactory/swagger.json, notebook/swagger.json, ontology/swagger.json, operationsAgent/swagger.json, orgApp/swagger.json, orgAppAudience/swagger.json, paginatedReport/swagger.json, plan/swagger.json, policySet/swagger.json, realTimeIntelligence/swagger.json, reflex/swagger.json, report/swagger.json, semanticModel/swagger.json, snowflakeDatabase/swagger.json, spark/swagger.json, sparkjobdefinition/swagger.json, sqlDatabase/swagger.json, sqlEndpoint/swagger.json, userDataFunction/swagger.json, variableLibrary/swagger.json, warehouse/swagger.json)'
servers:
- url: https://api.fabric.microsoft.com/v1
security: []
tags:
- name: MaterializedLakeViews
paths:
/workspaces/{workspaceId}/lakehouses/{lakehouseId}/mlvexecutiondefinitions:
post:
summary: Creates a materialized lake views execution definition
description: '## 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'
tags:
- MaterializedLakeViews
operationId: MaterializedLakeViews_CreateMlvExecutionDefinition
parameters:
- in: path
name: workspaceId
description: The workspace ID.
required: true
schema:
type: string
format: uuid
- in: path
name: lakehouseId
description: The lakehouse ID.
required: true
schema:
type: string
format: uuid
responses:
'201':
description: 'Successfully created the materialized lake views execution definition.
Response headers:
* `Location` - The URL of the newly created materialized lake views execution definition.'
content:
application/json:
schema:
$ref: '#/components/schemas/MaterializedLakeViewExecutionDefinition'
'429':
description: 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.
x-ms-error-response: true
headers:
Retry-After:
description: The number of seconds to wait before retrying the request.
schema:
type: integer
content:
application/json:
schema:
$ref: '#/components/schemas/ErrorResponse'
default:
description: '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 materialized lake views execution definition already exists'
content:
application/json:
schema:
$ref: '#/components/schemas/ErrorResponse'
requestBody:
content:
application/json:
schema:
$ref: '#/components/schemas/CreateMaterializedLakeViewExecutionDefinitionRequest'
description: Create materialized lake views execution definition request payload.
required: true
get:
summary: Returns a list of materialized lake views execution definitions for a lakehouse
description: 'This API supports pagination.
## Permissions
The caller must have *viewer* or higher workspace role.
## Required Delegated Scopes
Lakehouse.Read.All or Lakehouse.ReadWrite.All or Item.Read.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'
tags:
- MaterializedLakeViews
operationId: MaterializedLakeViews_ListMlvExecutionDefinitions
x-ms-pageable:
nextLinkName: continuationUri
parameters:
- in: path
name: workspaceId
description: The workspace ID.
required: true
schema:
type: string
format: uuid
- in: path
name: lakehouseId
description: The lakehouse ID.
required: true
schema:
type: string
format: uuid
- in: query
name: continuationToken
description: A token for retrieving the next page of results.
required: false
schema:
type: string
responses:
'200':
description: Request completed successfully.
content:
application/json:
schema:
$ref: '#/components/schemas/MaterializedLakeViewExecutionDefinitions'
'429':
description: 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.
x-ms-error-response: true
headers:
Retry-After:
description: The number of seconds to wait before retrying the request.
schema:
type: integer
content:
application/json:
schema:
$ref: '#/components/schemas/ErrorResponse'
default:
description: 'Common error codes:
* InsufficientPrivileges - The caller does not have sufficient permissions
* ItemNotFound - Requested item ID not found'
content:
application/json:
schema:
$ref: '#/components/schemas/ErrorResponse'
/workspaces/{workspaceId}/lakehouses/{lakehouseId}/mlvexecutiondefinitions/{mlvExecutionDefinitionId}:
get:
summary: Returns the specified materialized lake views execution definition
description: '## Permissions
The caller must have *viewer* or higher workspace role.
## Required Delegated Scopes
Lakehouse.Read.All or Lakehouse.ReadWrite.All or Item.Read.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'
tags:
- MaterializedLakeViews
operationId: MaterializedLakeViews_GetMlvExecutionDefinition
parameters:
- in: path
name: workspaceId
description: The workspace ID.
required: true
schema:
type: string
format: uuid
- in: path
name: lakehouseId
description: The lakehouse ID.
required: true
schema:
type: string
format: uuid
- in: path
name: mlvExecutionDefinitionId
description: The materialized lake views execution definition ID.
required: true
schema:
type: string
format: uuid
responses:
'200':
description: Request completed successfully.
content:
application/json:
schema:
$ref: '#/components/schemas/MaterializedLakeViewExecutionDefinition'
'429':
description: 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.
x-ms-error-response: true
headers:
Retry-After:
description: The number of seconds to wait before retrying the request.
schema:
type: integer
content:
application/json:
schema:
$ref: '#/components/schemas/ErrorResponse'
default:
description: 'Common error codes:
* InsufficientPrivileges - The caller does not have sufficient permissions
* ItemNotFound - Requested item ID not found'
content:
application/json:
schema:
$ref: '#/components/schemas/ErrorResponse'
patch:
summary: Updates the specified materialized lake views execution definition
description: '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'
tags:
- MaterializedLakeViews
operationId: MaterializedLakeViews_UpdateMlvExecutionDefinition
parameters:
- in: path
name: workspaceId
description: The workspace ID.
required: true
schema:
type: string
format: uuid
- in: path
name: lakehouseId
description: The lakehouse ID.
required: true
schema:
type: string
format: uuid
- in: path
name: mlvExecutionDefinitionId
description: The materialized lake views execution definition ID.
required: true
schema:
type: string
format: uuid
responses:
'200':
description: Request completed successfully.
content:
application/json:
schema:
$ref: '#/components/schemas/MaterializedLakeViewExecutionDefinition'
'429':
description: 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.
x-ms-error-response: true
headers:
Retry-After:
description: The number of seconds to wait before retrying the request.
schema:
type: integer
content:
application/json:
schema:
$ref: '#/components/schemas/ErrorResponse'
default:
description: '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'
content:
application/json:
schema:
$ref: '#/components/schemas/ErrorResponse'
requestBody:
content:
application/json:
schema:
$ref: '#/components/schemas/UpdateMaterializedLakeViewExecutionDefinitionRequest'
description: Update materialized lake views execution definition request payload.
required: true
delete:
summary: Deletes the specified materialized lake views execution definition
description: '## 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'
tags:
- MaterializedLakeViews
operationId: MaterializedLakeViews_DeleteMlvExecutionDefinition
parameters:
- in: path
name: workspaceId
description: The workspace ID.
required: true
schema:
type: string
format: uuid
- in: path
name: lakehouseId
description: The lakehouse ID.
required: true
schema:
type: string
format: uuid
- in: path
name: mlvExecutionDefinitionId
description: The materialized lake views execution definition ID.
required: true
schema:
type: string
format: uuid
responses:
'200':
description: Request completed successfully.
'429':
description: 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.
x-ms-error-response: true
headers:
Retry-After:
description: The number of seconds to wait before retrying the request.
schema:
type: integer
content:
application/json:
schema:
$ref: '#/components/schemas/ErrorResponse'
default:
description: 'Common error codes:
* InsufficientPrivileges - The caller does not have sufficient permissions
* ItemNotFound - Requested item ID not found'
content:
application/json:
schema:
$ref: '#/components/schemas/ErrorResponse'
components:
schemas:
ExecutionContextMode:
type: string
description: The execution context mode. Additional `ExecutionContextMode` types may be added over time.
enum:
- All
- Selected
x-ms-enum:
name: ExecutionContextMode
modelAsString: true
values:
- value: All
description: All items are included in the execution boundary.
- value: Selected
description: Only selected items are included in the execution boundary.
MaterializedLakeViewExecutionDefinition:
description: A materialized lake views execution definition object.
type: object
required:
- id
- displayName
- currentLakehouseExecutionContext
properties:
id:
description: The materialized lake views execution definition ID.
type: string
format: uuid
readOnly: true
displayName:
description: The materialized lake views execution definition display name.
type: string
readOnly: false
description:
description: A short description of the materialized lake views execution definition.
type: string
readOnly: false
settings:
$ref: '#/components/schemas/MaterializedLakeViewExecutionDefinitionSettingsResponse'
currentLakehouseExecutionContext:
$ref: '#/components/schemas/CurrentLakehouseExecutionContext'
extendedLineageExecutionContext:
$ref: '#/components/schemas/ExtendedLineageExecutionContextResponse'
ItemReferenceById:
description: An item reference by ID object.
type: object
required:
- itemId
- workspaceId
properties:
itemId:
description: The ID of the item.
type: string
format: uuid
workspaceId:
description: The workspace ID of the item.
type: string
format: uuid
allOf:
- $ref: '#/components/schemas/ItemReference'
x-ms-discriminator-value: ById
ErrorResponseDetails:
description: The error response details.
type: object
required:
- message
- errorCode
properties:
errorCode:
type: string
description: A specific identifier that provides information about an error condition, allowing for standardized communication between our service and its users.
readOnly: true
message:
type: string
description: A human readable representation of the error.
readOnly: true
relatedResource:
$ref: '#/components/schemas/ErrorRelatedResource'
parameters:
description: Structured parameters providing additional machine-readable context about the error.
type: array
items:
$ref: '#/components/schemas/ErrorParameter'
readOnly: true
MaterializedLakeViewExecutionDefinitionSettingsResponse:
description: The materialized lake views execution definition settings (response).
type: object
properties:
environment:
$ref: '#/components/schemas/ItemReference'
refreshMode:
$ref: '#/components/schemas/RefreshMode'
MaterializedLakeViewExecutionDefinitions:
description: A list of materialized lake view execution definitions.
required:
- value
type: object
properties:
value:
description: A list of materialized lake view execution definitions.
type: array
items:
$ref: '#/components/schemas/MaterializedLakeViewExecutionDefinition'
allOf:
- $ref: '#/components/schemas/PaginatedResponse'
ItemReference:
description: An item reference object.
type: object
required:
- referenceType
discriminator:
propertyName: referenceType
properties:
referenceType:
$ref: '#/components/schemas/ItemReferenceType'
ExtendedLineageExecutionContextResponse:
description: The extended lineage execution context for a materialized lake views execution definition (response).
type: object
required:
- mode
discriminator:
propertyName: mode
properties:
mode:
$ref: '#/components/schemas/ExecutionContextMode'
CurrentLakehouseExecutionContext:
description: The current lakehouse execution context for a materialized lake views execution definition.
type: object
required:
- mode
discriminator:
propertyName: mode
properties:
mode:
$ref: '#/components/schemas/ExecutionContextMode'
MaterializedLakeViewExecutionDefinitionSettingsRequest:
description: The materialized lake views execution definition settings.
type: object
properties:
environment:
$ref: '#/components/schemas/ItemReferenceById'
refreshMode:
$ref: '#/components/schemas/RefreshMode'
ErrorParameter:
description: A structured parameter providing additional machine-readable context about an error.
type: object
properties:
name:
type: string
description: The parameter identifier.
readOnly: true
value:
type: string
description: The parameter value.
readOnly: true
message:
type: string
description: A human-readable description of the parameter's meaning.
readOnly: true
ErrorResponse:
description: The error response.
required:
- message
- errorCode
allOf:
- $ref: '#/components/schemas/ErrorResponseDetails'
properties:
requestId:
type: string
format: uuid
description: ID of the request associated with the error.
readOnly: true
moreDetails:
description: List of additional error details.
type: array
items:
$ref: '#/components/schemas/ErrorResponseDetails'
readOnly: true
isRetriable:
type: boolean
description: When true, the request can be retried. Use the `Retry-After` response header to determine the delay, if available.
readOnly: true
ErrorRelatedResource:
description: The error related resource details object.
type: object
required:
- resourceId
- resourceType
properties:
resourceId:
type: string
description: The resource ID that's involved in the error.
readOnly: true
resourceType:
type: string
description: The type of the resource that's involved in the error.
readOnly: true
ExtendedLineageExecutionContextRequest:
description: The extended lineage execution context for a materialized lake views execution definition.
type: object
required:
- mode
discriminator:
propertyName: mode
properties:
mode:
$ref: '#/components/schemas/ExecutionContextMode'
UpdateMaterializedLakeViewExecutionDefinitionRequest:
description: Update materialized lake views execution definition request payload. Only the fields provided are updated; omitted fields retain their existing values.
type: object
properties:
displayName:
description: The materialized lake views execution definition display name.
type: string
readOnly: false
description:
description: A short description of the materialized lake views execution definition.
type: string
readOnly: false
settings:
$ref: '#/components/schemas/MaterializedLakeViewExecutionDefinitionSettingsRequest'
currentLakehouseExecutionContext:
$ref: '#/components/schemas/CurrentLakehouseExecutionContext'
extendedLineageExecutionContext:
$ref: '#/components/schemas/ExtendedLineageExecutionContextRequest'
ItemReferenceType:
type: string
description: The item reference type. Additional `ItemReferenceType` types may be added over time.
enum:
- ById
- ByVariable
x-ms-enum:
name: ItemReferenceType
modelAsString: true
values:
- value: ById
description: The item is referenced by its ID.
- value: ByVariable
description: The item is referenced by a variable.
PaginatedResponse:
properties:
continuationToken:
type: string
description: The token for the next result set batch. If there are no more records, it's removed from the response.
continuationUri:
type: string
description: The URI of the next result set batch. If there are no more records, it's removed from the response.
RefreshMode:
type: string
description: The refresh mode for the execution definition. Additional `RefreshMode` types may be added over time.
enum:
- Optimal
- Full
x-ms-enum:
name: RefreshMode
modelAsString: true
values:
- value: Optimal
description: This mode chooses the best strategy to maximize performance from among incremental, full, or no recompute while refreshing each materialized lake view.
- value: Full
description: This mode enforces the full recompute for materialized lake views being refreshed.
CreateMaterializedLakeViewExecutionDefinitionRequest:
description: Create materialized lake views execution definition request payload.
type: object
required:
- displayName
- currentLakehouseExecutionContext
properties:
displayName:
description: The materialized lake views execution definition display name.
type: string
readOnly: false
description:
description: A short description of the materialized lake views execution definition.
type: string
readOnly: false
settings:
$ref: '#/components/schemas/MaterializedLakeViewExecutionDefinitionSettingsRequest'
currentLakehouseExecutionContext:
$ref: '#/components/schemas/CurrentLakehouseExecutionContext'
extendedLineageExecutionContext:
$ref: '#/components/schemas/ExtendedLineageExecutionContextRequest'