provider_share_subscriptions

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

Overview

Name	provider_share_subscriptions
Type	Resource
Id	azure.data_share.provider_share_subscriptions

Fields

vw_provider_share_subscriptions

Name	Datatype	Description
id	text	The resource id of the azure resource
name	text	Name of the azure resource
accountName	text	field from the properties object
consumer_email	text	field from the properties object
consumer_name	text	field from the properties object
consumer_tenant_name	text	field from the properties object
created_at	text	field from the properties object
expiration_date	text	field from the properties object
providerShareSubscriptionId	text	field from the properties object
provider_email	text	field from the properties object
provider_name	text	field from the properties object
resourceGroupName	text	field from the properties object
shareName	text	field from the properties object
share_subscription_object_id	text	field from the properties object
share_subscription_status	text	field from the properties object
shared_at	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
type	text	Type of the azure resource

provider_share_subscriptions

Name	Datatype	Description
id	string	The resource id of the azure resource
name	string	Name of the azure resource
properties	object	Provider share subscription properties
systemData	object	Metadata pertaining to creation and last modification of the resource.
type	string	Type of the azure resource

Methods

Name	Accessible by	Required Params	Description
get_by_share	SELECT	accountName, providerShareSubscriptionId, resourceGroupName, shareName, subscriptionId	Get share subscription in a provider share
list_by_share	SELECT	accountName, resourceGroupName, shareName, subscriptionId	List share subscriptions in a provider share
adjust	EXEC	accountName, providerShareSubscriptionId, resourceGroupName, shareName, subscriptionId	Adjust a share subscription's expiration date in a provider share
reinstate	EXEC	accountName, providerShareSubscriptionId, resourceGroupName, shareName, subscriptionId	Reinstate share subscription in a provider share
revoke	EXEC	accountName, providerShareSubscriptionId, resourceGroupName, shareName, subscriptionId	Revoke share subscription in a provider share

SELECT examples

List share subscriptions in a provider share

vw_provider_share_subscriptions

SELECT
id,
name,
accountName,
consumer_email,
consumer_name,
consumer_tenant_name,
created_at,
expiration_date,
providerShareSubscriptionId,
provider_email,
provider_name,
resourceGroupName,
shareName,
share_subscription_object_id,
share_subscription_status,
shared_at,
subscriptionId,
system_data,
type
FROM azure.data_share.vw_provider_share_subscriptions
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND shareName = '{{ shareName }}'
AND subscriptionId = '{{ subscriptionId }}';

provider_share_subscriptions

SELECT
id,
name,
properties,
systemData,
type
FROM azure.data_share.provider_share_subscriptions
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND shareName = '{{ shareName }}'
AND subscriptionId = '{{ subscriptionId }}';