Items - Create Warehouse Snapshot

Service:

WarehouseSnapshot

API Version:

v1

Creates a Warehouse snapshot in the specified workspace.
This API supports long running operations (LRO).

Permissions

The caller must have a contributor workspace role.

Required Delegated Scopes

WarehouseSnapshot.ReadWrite.All or Item.ReadWrite.All

Limitations

• To create a Warehouse snapshot the workspace must be on a supported Fabric capacity. For more information see: Microsoft Fabric license types.

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

POST https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/warehousesnapshots

URI Parameters

Name	In	Required	Type	Description
workspaceId	path	True	string (uuid)	The workspace ID.

Request Body

Name	Required	Type	Description
displayName	True	string	The Warehouse snapshot display name. The display name must follow naming rules according to item type.
creationPayload		WarehouseSnapshotCreationPayload	The Warehouse snapshot creation payload.
description		string	The Warehouse snapshot description. Maximum length is 256 characters.
folderId		string (uuid)	The folder ID. If not specified or null, the Warehouse snapshot is created with the workspace as its folder.

Responses

Name	Type	Description
201 Created	WarehouseSnapshot	Successfully created
202 Accepted		Request accepted, Warehouse snapshot provisioning in progress. Headers Location: string x-ms-operation-id: string Retry-After: integer
Other Status Codes	ErrorResponse	Common error codes: InvalidItemType - Item type is invalid ItemDisplayNameAlreadyInUse - Item display name is already used. CorruptedPayload - The provided payload is corrupted. WorkspaceItemsLimitExceeded - Workspace item limit exceeded.

Examples

Create a Warehouse snapshot example

Sample request

HTTP

POST https://api.fabric.microsoft.com/v1/workspaces/cfafbeb1-8037-4d0c-896e-a46fb27ff229/warehousesnapshots

{
  "displayName": "WarehouseSnapshot 1",
  "description": "A WarehouseSnapshot description.",
  "creationPayload": {
    "parentWarehouseId": "7332259c-fb34-4975-99db-85818fb8664f",
    "snapshotDateTime": "2024-10-15T13:00:00Z"
  }
}

Sample response

Status code:

201

{
  "displayName": "WarehouseSnapshot 1",
  "description": "A WarehouseSnapshot description.",
  "type": "WarehouseSnapshot",
  "workspaceId": "cfafbeb1-8037-4d0c-896e-a46fb27ff229",
  "id": "5b218778-e7a5-4d73-8187-f10824047715"
}

Status code:

202

Location: https://api.fabric.microsoft.com/v1/operations/0acd697c-1550-43cd-b998-91bfbfbd47c6
x-ms-operation-id: 0acd697c-1550-43cd-b998-91bfbfbd47c6
Retry-After: 30

Definitions

Name	Description
CreateWarehouseSnapshotRequest	Create Warehouse snapshot request payload.
ErrorRelatedResource	The error related resource details object.
ErrorResponse	The error response.
ErrorResponseDetails	The error response details.
ItemTag	Represents a tag applied on an item.
ItemType	The type of the item. Additional item types may be added over time.
WarehouseSnapshot	A Warehouse snapshot object.
WarehouseSnapshotCreationPayload	The Warehouse snapshot creation payload.
WarehouseSnapshotProperties	The Warehouse snapshot properties.

CreateWarehouseSnapshotRequest

Object

Create Warehouse snapshot request payload.

Name	Type	Description
creationPayload	WarehouseSnapshotCreationPayload	The Warehouse snapshot creation payload.
description	string	The Warehouse snapshot description. Maximum length is 256 characters.
displayName	string	The Warehouse snapshot display name. The display name must follow naming rules according to item type.
folderId	string (uuid)	The folder ID. If not specified or null, the Warehouse snapshot is created with the workspace as its folder.

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.
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	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.

ItemTag

Object

Represents a tag applied on an item.

Name	Type	Description
displayName	string	The name of the tag.
id	string (uuid)	The tag ID.

ItemType

Enumeration

The type of the item. Additional item types may be added over time.

Value	Description
Dashboard	PowerBI dashboard.
Report	PowerBI report.
SemanticModel	PowerBI semantic model.
PaginatedReport	PowerBI paginated report.
Datamart	PowerBI datamart.
Lakehouse	A lakehouse.
Eventhouse	An eventhouse.
Environment	An environment.
KQLDatabase	A KQL database.
KQLQueryset	A KQL queryset.
KQLDashboard	A KQL dashboard.
DataPipeline	A data pipeline.
Notebook	A notebook.
SparkJobDefinition	A spark job definition.
MLExperiment	A machine learning experiment.
MLModel	A machine learning model.
Warehouse	A warehouse.
Eventstream	An eventstream.
SQLEndpoint	An SQL endpoint.
MirroredWarehouse	A mirrored warehouse.
MirroredDatabase	A mirrored database.
Reflex	A Reflex.
GraphQLApi	An API for GraphQL item.
MountedDataFactory	A MountedDataFactory.
SQLDatabase	A SQLDatabase.
CopyJob	A Copy job.
VariableLibrary	A VariableLibrary.
Dataflow	A Dataflow.
ApacheAirflowJob	An ApacheAirflowJob.
WarehouseSnapshot	A Warehouse snapshot.
DigitalTwinBuilder	A DigitalTwinBuilder.
DigitalTwinBuilderFlow	A Digital Twin Builder Flow.
MirroredAzureDatabricksCatalog	A mirrored azure databricks catalog.

WarehouseSnapshot

Object

A Warehouse snapshot object.

Name	Type	Description
description	string	The item description.
displayName	string	The item display name.
folderId	string (uuid)	The folder ID.
id	string (uuid)	The item ID.
properties	WarehouseSnapshotProperties	The Warehouse snapshot properties.
tags	ItemTag[]	List of applied tags.
type	ItemType	The item type.
workspaceId	string (uuid)	The workspace ID.

WarehouseSnapshotCreationPayload

Object

The Warehouse snapshot creation payload.

Name	Type	Description
parentWarehouseId	string (uuid)	The parent Warehouse ID.
snapshotDateTime	string (date-time)	The date and time used for the Warehouse snapshot, if not provided the current date and time will be taken. If given it should be in UTC, using the YYYY-MM-DDTHH:mm:ssZ format.

WarehouseSnapshotProperties

Object

The Warehouse snapshot properties.

Name	Type	Description
connectionString	string	The SQL connection string connected to the workspace containing this warehouse.
parentWarehouseId	string	The parent Warehouse ID.
snapshotDateTime	string (date-time)	The current warehouse snapshot date and time in UTC, using the YYYY-MM-DDTHH:mm:ssZ format.