Skip to main content

shares

Creates, updates, deletes, gets or lists a shares resource.

Overview

Nameshares
TypeResource
Idazure.data_share.shares

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringThe resource id of the azure resource.
namestringName of the azure resource.
createdAtstring (date-time)Time at which the share was created.
descriptionstringShare description.
provisioningStatestringGets or sets the provisioning state. Known values are: "Succeeded", "Creating", "Deleting", "Moving", and "Failed".
shareKindstringShare kind. Known values are: "CopyBased" and "InPlace".
systemDataobjectSystem Data of the Azure resource.
termsstringShare terms.
typestringType of the azure resource.
userEmailstringEmail of the user who created the resource.
userNamestringName of the user who created the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, account_name, share_name, subscription_idGet a specified share. Get a share.
list_by_accountselectresource_group_name, account_name, subscription_id$skipToken, $filter, $orderbyList of available shares under an account. List shares in an account.
createinsertresource_group_name, account_name, share_name, subscription_idCreate a share in the given account. Create a share.
deletedeleteresource_group_name, account_name, share_name, subscription_idDeletes a share. Delete a share.
list_synchronization_detailsexecresource_group_name, account_name, share_name, subscription_id$skipToken, $filter, $orderbyList data set level details for a share synchronization. List synchronization details.
list_synchronizationsexecresource_group_name, account_name, share_name, subscription_id$skipToken, $filter, $orderbyList Synchronizations in a share. List synchronizations of a share.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
account_namestringThe name of the share account. Required.
resource_group_namestringThe resource group name. Required.
share_namestringThe name of the share. Required.
subscription_idstring
$filterstringFilters the results using OData syntax. Default value is None.
$orderbystringSorts the results using OData syntax. Default value is None.
$skipTokenstringContinuation token. Default value is None.

SELECT examples

Get a specified share. Get a share.

SELECT
id,
name,
createdAt,
description,
provisioningState,
shareKind,
systemData,
terms,
type,
userEmail,
userName
FROM azure.data_share.shares
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND account_name = '{{ account_name }}' -- required
AND share_name = '{{ share_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create a share in the given account. Create a share.

INSERT INTO azure.data_share.shares (
properties,
resource_group_name,
account_name,
share_name,
subscription_id
)
SELECT
'{{ properties }}',
'{{ resource_group_name }}',
'{{ account_name }}',
'{{ share_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
systemData,
type
;

DELETE examples

Deletes a share. Delete a share.

DELETE FROM azure.data_share.shares
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND account_name = '{{ account_name }}' --required
AND share_name = '{{ share_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

List data set level details for a share synchronization. List synchronization details.

EXEC azure.data_share.shares.list_synchronization_details 
@resource_group_name='{{ resource_group_name }}' --required,
@account_name='{{ account_name }}' --required,
@share_name='{{ share_name }}' --required,
@subscription_id='{{ subscription_id }}' --required,
@$skipToken='{{ $skipToken }}',
@$filter='{{ $filter }}',
@$orderby='{{ $orderby }}'
@@json=
'{
"consumerEmail": "{{ consumerEmail }}",
"consumerName": "{{ consumerName }}",
"consumerTenantName": "{{ consumerTenantName }}",
"durationMs": {{ durationMs }},
"endTime": "{{ endTime }}",
"message": "{{ message }}",
"startTime": "{{ startTime }}",
"status": "{{ status }}",
"synchronizationId": "{{ synchronizationId }}"
}'
;