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
propertiesobjectProperties on the share
systemDataobjectSystem Data of the Azure resource.
typestringType of the azure resource

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, accountName, shareNameapi-versionGet a share
list_by_accountselectsubscriptionId, resourceGroupName, accountNameapi-version, $skipToken, $filter, $orderbyList shares in an account
createinsertsubscriptionId, resourceGroupName, accountName, shareNameapi-versionCreate a share
deletedeletesubscriptionId, resourceGroupName, accountName, shareNameapi-versionDelete 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
accountNamestringThe name of the share account.
resourceGroupNamestringThe resource group name.
shareNamestringThe name of the share.
subscriptionIdstringThe subscription identifier
$filterstringFilters the results using OData syntax.
$orderbystringSorts the results using OData syntax.
$skipTokenstringContinuation Token
api-versionstringThe api version to use.

SELECT examples

Get a share

SELECT
id,
name,
properties,
systemData,
type
FROM azure.data_share.shares
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND accountName = '{{ accountName }}' -- required
AND shareName = '{{ shareName }}' -- required
AND api-version = '{{ api-version }}'
;

INSERT examples

Create a share

INSERT INTO azure.data_share.shares (
data__properties,
subscriptionId,
resourceGroupName,
accountName,
shareName,
api-version
)
SELECT
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ accountName }}',
'{{ shareName }}',
'{{ api-version }}'
RETURNING
id,
name,
properties,
systemData,
type
;

DELETE examples

Delete a share

DELETE FROM azure.data_share.shares
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND accountName = '{{ accountName }}' --required
AND shareName = '{{ shareName }}' --required
AND api-version = '{{ api-version }}'
;