data_sets

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

Overview

Name	data_sets
Type	Resource
Id	azure.data_share.data_sets

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.
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, dataSetName, resourceGroupName, shareName, subscriptionId	Get a DataSet in a share
list_by_share	SELECT	accountName, resourceGroupName, shareName, subscriptionId	List DataSets in a share
create	INSERT	accountName, dataSetName, resourceGroupName, shareName, subscriptionId, data__kind	Create a DataSet
delete	DELETE	accountName, dataSetName, resourceGroupName, shareName, subscriptionId	Delete a DataSet in a share

SELECT examples

List DataSets in a share

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

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.data_share.data_sets (
accountName,
dataSetName,
resourceGroupName,
shareName,
subscriptionId,
data__kind,
kind
)
SELECT 
'{{ accountName }}',
'{{ dataSetName }}',
'{{ resourceGroupName }}',
'{{ shareName }}',
'{{ 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_sets resource.

/*+ delete */
DELETE FROM azure.data_share.data_sets
WHERE accountName = '{{ accountName }}'
AND dataSetName = '{{ dataSetName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND shareName = '{{ shareName }}'
AND subscriptionId = '{{ subscriptionId }}';