accounts

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

Overview

Name	accounts
Type	Resource
Id	azure.data_share.accounts

Fields

vw_accounts

Name	Datatype	Description
accountName	text	field from the properties object
created_at	text	field from the properties object
identity	text	Identity of resource
location	text	Location of the azure resource.
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Tags on the azure resource.
user_email	text	field from the properties object
user_name	text	field from the properties object

accounts

Name	Datatype	Description
identity	object	Identity of resource
location	string	Location of the azure resource.
properties	object	Account property bag.
tags	object	Tags on the azure resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accountName, resourceGroupName, subscriptionId	Get an account
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	List Accounts in ResourceGroup
list_by_subscription	SELECT	subscriptionId	List Accounts in Subscription
create	INSERT	accountName, resourceGroupName, subscriptionId, data__identity	Create an account
delete	DELETE	accountName, resourceGroupName, subscriptionId	DeleteAccount
update	UPDATE	accountName, resourceGroupName, subscriptionId	Patch an account

SELECT examples

List Accounts in Subscription

vw_accounts

SELECT
accountName,
created_at,
identity,
location,
provisioning_state,
resourceGroupName,
subscriptionId,
tags,
user_email,
user_name
FROM azure.data_share.vw_accounts
WHERE subscriptionId = '{{ subscriptionId }}';

accounts

SELECT
identity,
location,
properties,
tags
FROM azure.data_share.accounts
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.data_share.accounts (
accountName,
resourceGroupName,
subscriptionId,
data__identity,
location,
tags,
identity,
properties
)
SELECT 
'{{ accountName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__identity }}',
'{{ location }}',
'{{ tags }}',
'{{ identity }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: location
      value: string
    - name: tags
      value: object
    - name: identity
      value:
        - name: principalId
          value: string
        - name: tenantId
          value: string
        - name: type
          value: string
    - name: properties
      value:
        - name: createdAt
          value: string
        - name: provisioningState
          value: string
        - name: userEmail
          value: string
        - name: userName
          value: string

UPDATE example

Updates a accounts resource.

/*+ update */
UPDATE azure.data_share.accounts
SET 
tags = '{{ tags }}'
WHERE 
accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified accounts resource.

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