data_set_mappings

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

Overview

Name	data_set_mappings
Type	Resource
Id	azure.data_share.data_set_mappings

Fields

Name	Datatype	Description
id	string	The resource id of the azure resource
name	string	Name of the azure resource
kind	string	Kind of data set mapping.
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	SELECT	accountName, dataSetMappingName, resourceGroupName, shareSubscriptionName, subscriptionId	Get a DataSetMapping in a shareSubscription
list_by_share_subscription	SELECT	accountName, resourceGroupName, shareSubscriptionName, subscriptionId	List DataSetMappings in a share subscription
create	INSERT	accountName, dataSetMappingName, resourceGroupName, shareSubscriptionName, subscriptionId, data__kind	Create a DataSetMapping
delete	DELETE	accountName, dataSetMappingName, resourceGroupName, shareSubscriptionName, subscriptionId	Delete a DataSetMapping in a shareSubscription

SELECT examples

List DataSetMappings in a share subscription

SELECT
id,
name,
kind,
systemData,
type
FROM azure.data_share.data_set_mappings
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND shareSubscriptionName = '{{ shareSubscriptionName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new data_set_mappings resource.

All Properties

/*+ create */
INSERT INTO azure.data_share.data_set_mappings (
accountName,
dataSetMappingName,
resourceGroupName,
shareSubscriptionName,
subscriptionId,
data__kind,
kind
)
SELECT 
'{{ accountName }}',
'{{ dataSetMappingName }}',
'{{ resourceGroupName }}',
'{{ shareSubscriptionName }}',
'{{ subscriptionId }}',
'{{ data__kind }}',
'{{ kind }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: systemData
      value:
        - name: createdAt
          value: string
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: lastModifiedAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
    - name: type
      value: string
    - name: kind
      value: string

DELETE example

Deletes the specified data_set_mappings resource.

/*+ delete */
DELETE FROM azure.data_share.data_set_mappings
WHERE accountName = '{{ accountName }}'
AND dataSetMappingName = '{{ dataSetMappingName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND shareSubscriptionName = '{{ shareSubscriptionName }}'
AND subscriptionId = '{{ subscriptionId }}';