Database Extensions - Create Or Update
Perform a database extension operation, like polybase import
PUT https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/extensions/{extensionName}?api-version=2021-02-01-preview
URI Parameters
Name | In | Required | Type | Description |
---|---|---|---|---|
database
|
path | True |
|
The name of the database. |
extension
|
path | True |
|
|
resource
|
path | True |
|
The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal. |
server
|
path | True |
|
The name of the server. |
subscription
|
path | True |
|
The subscription ID that identifies an Azure subscription. |
api-version
|
query | True |
|
The API version to use for the request. |
Request Body
Name | Required | Type | Description |
---|---|---|---|
properties.operationMode | True |
Operation Mode. |
|
properties.storageKey | True |
|
Storage key. |
properties.storageKeyType | True |
Storage key type. |
|
properties.storageUri | True |
|
Storage Uri. |
Responses
Name | Type | Description |
---|---|---|
200 OK |
Successfully completed import/export operation. |
|
202 Accepted |
Import/Export operation is in progress. |
|
Other Status Codes |
*** Error Responses: ***
|
Examples
Create or Update database extensions.
Sample Request
PUT https://management.azure.com/subscriptions/a1c0814d-3c18-4e1e-a247-c128c12b1677/resourceGroups/rg_20cbe0f0-c2d9-4522-9177-5469aad53029/providers/Microsoft.Sql/servers/srv_1ffd1cf8-9951-47fb-807d-a9c384763849/databases/878e303f-1ea0-4f17-aa3d-a22ac5e9da08/extensions/polybaseimport?api-version=2021-02-01-preview
{
"properties": {
"operationMode": "PolybaseImport",
"storageKeyType": "StorageAccessKey",
"storageKey": "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"storageUri": "https://teststorage.blob.core.windows.net/testcontainer/Manifest.xml"
}
}
Sample Response
{
"properties": {
"requestId": "10000000-0000-0000-0000-000000000002",
"requestType": "PolybaseImport",
"lastModifiedTime": "lastModifiedTime",
"serverName": "srv_1ffd1cf8-9951-47fb-807d-a9c384763849",
"databaseName": "878e303f-1ea0-4f17-aa3d-a22ac5e9da08",
"status": "succeeded"
},
"id": "10000000-0000-0000-0000-000000000002",
"name": "10000000-0000-0000-0000-000000000002",
"type": "Microsoft.Sql/servers/databases/extensions"
}
Definitions
Database |
An export managed database operation result resource. |
Import |
An Extension operation result resource. |
Operation |
Operation Mode. |
Storage |
Storage key type. |
DatabaseExtensions
An export managed database operation result resource.
Name | Type | Description |
---|---|---|
id |
|
Resource ID. |
name |
|
Resource name. |
properties.operationMode |
Operation Mode. |
|
properties.storageKey |
|
Storage key. |
properties.storageKeyType |
Storage key type. |
|
properties.storageUri |
|
Storage Uri. |
type |
|
Resource type. |
ImportExportExtensionsOperationResult
An Extension operation result resource.
Name | Type | Description |
---|---|---|
id |
|
Resource ID. |
name |
|
Resource name. |
properties.databaseName |
|
Database name. |
properties.errorMessage |
|
Error message. |
properties.lastModifiedTime |
|
Last modified time. |
properties.requestId |
|
Request Id. |
properties.requestType |
|
Request type. |
properties.serverName |
|
Server name. |
properties.status |
|
Operation status. |
type |
|
Resource type. |
OperationMode
Operation Mode.
Name | Type | Description |
---|---|---|
PolybaseImport |
|
StorageKeyType
Storage key type.
Name | Type | Description |
---|---|---|
SharedAccessKey |
|
|
StorageAccessKey |
|