organizations

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

Overview

Name	organizations
Type	Resource
Id	azure_isv.astro.organizations

Fields

vw_organizations

Name	Datatype	Description
identity	text	Managed service identity (system assigned and/or user assigned identities)
location	text	The geo-location where the resource lives
marketplace	text	field from the properties object
organizationName	text	field from the properties object
partner_organization_properties	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.
user	text	field from the properties object

organizations

Name	Datatype	Description
identity	object	Managed service identity (system assigned and/or user assigned identities)
location	string	The geo-location where the resource lives
properties	object	Properties specific to Data Organization resource
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	organizationName, resourceGroupName, subscriptionId	Get a OrganizationResource
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	List OrganizationResource resources by resource group
list_by_subscription	SELECT	subscriptionId	List OrganizationResource resources by subscription ID
create_or_update	INSERT	organizationName, resourceGroupName, subscriptionId	Create a OrganizationResource
delete	DELETE	organizationName, resourceGroupName, subscriptionId	Delete a OrganizationResource
update	UPDATE	organizationName, resourceGroupName, subscriptionId	Update a OrganizationResource

SELECT examples

List OrganizationResource resources by subscription ID

vw_organizations

SELECT
identity,
location,
marketplace,
organizationName,
partner_organization_properties,
provisioning_state,
resourceGroupName,
subscriptionId,
tags,
user
FROM azure_isv.astro.vw_organizations
WHERE subscriptionId = '{{ subscriptionId }}';

organizations

SELECT
identity,
location,
properties,
tags
FROM azure_isv.astro.organizations
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_isv.astro.organizations (
organizationName,
resourceGroupName,
subscriptionId,
properties,
identity,
tags,
location
)
SELECT 
'{{ organizationName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ identity }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: marketplace
          value:
            - name: subscriptionId
              value: string
            - name: subscriptionStatus
              value: []
            - name: offerDetails
              value:
                - name: publisherId
                  value: string
                - name: offerId
                  value: string
                - name: planId
                  value: string
                - name: planName
                  value: string
                - name: termUnit
                  value: string
                - name: termId
                  value: string
                - name: renewalMode
                  value: []
                - name: endDate
                  value: string
        - name: user
          value:
            - name: firstName
              value: string
            - name: lastName
              value: string
            - name: emailAddress
              value: []
            - name: upn
              value: string
            - name: phoneNumber
              value: string
        - name: provisioningState
          value: []
        - name: partnerOrganizationProperties
          value:
            - name: organizationId
              value: string
            - name: workspaceId
              value: string
            - name: organizationName
              value: string
            - name: workspaceName
              value: string
            - name: singleSignOnProperties
              value:
                - name: singleSignOnState
                  value: []
                - name: enterpriseAppId
                  value: string
                - name: singleSignOnUrl
                  value: []
                - name: aadDomains
                  value:
                    - string
    - name: identity
      value:
        - name: principalId
          value: string
        - name: tenantId
          value: string
        - name: type
          value: []
        - name: userAssignedIdentities
          value: []
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a organizations resource.

/*+ update */
UPDATE azure_isv.astro.organizations
SET 
identity = '{{ identity }}',
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
organizationName = '{{ organizationName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified organizations resource.

/*+ delete */
DELETE FROM azure_isv.astro.organizations
WHERE organizationName = '{{ organizationName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';