Items - Create Warehouse
Creates a warehouse in the specified workspace.
This API supports long running operations (LRO).
This API does not support create a warehouse with definition.
Permissions
The caller must have contributor or higher workspace role.
Required Delegated Scopes
Warehouse.ReadWrite.All or Item.ReadWrite.All
Limitations
- To create a warehouse 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 | No |
Managed identities | No |
Interface
POST https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/warehouses
URI Parameters
Name | In | Required | Type | Description |
---|---|---|---|---|
workspace
|
path | True |
string uuid |
The workspace ID. |
Request Body
Name | Required | Type | Description |
---|---|---|---|
displayName | True |
string |
The warehouse display name. The display name must follow naming rules according to item type. |
description |
string |
The warehouse description. Maximum length is 256 characters. |
Responses
Name | Type | Description |
---|---|---|
201 Created |
Successfully created |
|
202 Accepted |
Request accepted, warehouse provisioning in progress. Headers
|
|
Other Status Codes |
Common error codes:
|
Examples
Create a warehouse example
Sample request
POST https://api.fabric.microsoft.com/v1/workspaces/cfafbeb1-8037-4d0c-896e-a46fb27ff229/warehouses
{
"displayName": "Warehouse 1",
"description": "A warehouse description."
}
Sample response
{
"displayName": "Warehouse 1",
"description": "A warehouse description.",
"type": "Warehouse",
"workspaceId": "cfafbeb1-8037-4d0c-896e-a46fb27ff229",
"id": "5b218778-e7a5-4d73-8187-f10824047715"
}
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 |
---|---|
Create |
Create warehouse request payload. |
Error |
The error related resource details object. |
Error |
The error response. |
Error |
The error response details. |
Item |
The type of the item. Additional item types may be added over time. |
Warehouse |
A warehouse object. |
Warehouse |
The warehouse item properties. |
CreateWarehouseRequest
Create warehouse request payload.
Name | Type | Description |
---|---|---|
description |
string |
The warehouse description. Maximum length is 256 characters. |
displayName |
string |
The warehouse display name. The display name must follow naming rules according to item type. |
ErrorRelatedResource
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
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 |
List of additional error details. |
|
relatedResource |
The error related resource details. |
|
requestId |
string |
ID of the request associated with the error. |
ErrorResponseDetails
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 |
The error related resource details. |
ItemType
The type of the item. Additional item types may be added over time.
Name | Type | Description |
---|---|---|
Dashboard |
string |
PowerBI dashboard. |
DataPipeline |
string |
A data pipeline. |
Datamart |
string |
PowerBI datamart. |
Environment |
string |
An environment. |
Eventhouse |
string |
An eventhouse. |
Eventstream |
string |
An eventstream. |
KQLDashboard |
string |
A KQL dashboard. |
KQLDatabase |
string |
A KQL database. |
KQLQueryset |
string |
A KQL queryset. |
Lakehouse |
string |
A lakehouse. |
MLExperiment |
string |
A machine learning experiment. |
MLModel |
string |
A machine learning model. |
MirroredDatabase |
string |
A mirrored database. |
MirroredWarehouse |
string |
A mirrored warehouse. |
Notebook |
string |
A notebook. |
PaginatedReport |
string |
PowerBI paginated report. |
Reflex |
string |
A Reflex. |
Report |
string |
PowerBI report. |
SQLEndpoint |
string |
An SQL endpoint. |
SemanticModel |
string |
PowerBI semantic model. |
SparkJobDefinition |
string |
A spark job definition. |
Warehouse |
string |
A warehouse. |
Warehouse
A warehouse object.
Name | Type | Description |
---|---|---|
description |
string |
The item description. |
displayName |
string |
The item display name. |
id |
string |
The item ID. |
properties |
The warehouse properties. |
|
type |
The item type. |
|
workspaceId |
string |
The workspace ID. |
WarehouseProperties
The warehouse item properties.
Name | Type | Description |
---|---|---|
connectionString |
string |
The SQL connection string connected to the workspace containing this warehouse. |
createdDate |
string |
The date and time the warehouse was created. |
lastUpdatedTime |
string |
The date and time the warehouse was last updated |