associated_tenants

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

Overview

Name	associated_tenants
Type	Resource
Id	azure.billing.associated_tenants

Fields

vw_associated_tenants

Name	Datatype	Description
associatedTenantName	text	field from the properties object
billingAccountName	text	field from the properties object
billing_management_state	text	field from the properties object
display_name	text	field from the properties object
provisioning_billing_request_id	text	field from the properties object
provisioning_management_state	text	field from the properties object
provisioning_state	text	field from the properties object
tags	text	Dictionary of metadata associated with the resource. It may not be populated for all resource types. Maximum key/value length supported of 256 characters. Keys/value should not empty value nor null. Keys can not contain < > % & \ ? /
tenant_id	text	field from the properties object

associated_tenants

Name	Datatype	Description
properties	object	An associated tenant.
tags	object	Dictionary of metadata associated with the resource. It may not be populated for all resource types. Maximum key/value length supported of 256 characters. Keys/value should not empty value nor null. Keys can not contain < > % & \ ? /

Methods

Name	Accessible by	Required Params	Description
get	SELECT	associatedTenantName, billingAccountName	Gets an associated tenant by ID.
list_by_billing_account	SELECT	billingAccountName	Lists the associated tenants that can collaborate with the billing account on commerce activities like viewing and downloading invoices, managing payments, making purchases, and managing or provisioning licenses.
create_or_update	INSERT	associatedTenantName, billingAccountName	Create or update an associated tenant for the billing account.
delete	DELETE	associatedTenantName, billingAccountName	Deletes an associated tenant for a billing account.

SELECT examples

Lists the associated tenants that can collaborate with the billing account on commerce activities like viewing and downloading invoices, managing payments, making purchases, and managing or provisioning licenses.

vw_associated_tenants

SELECT
associatedTenantName,
billingAccountName,
billing_management_state,
display_name,
provisioning_billing_request_id,
provisioning_management_state,
provisioning_state,
tags,
tenant_id
FROM azure.billing.vw_associated_tenants
WHERE billingAccountName = '{{ billingAccountName }}';

associated_tenants

SELECT
properties,
tags
FROM azure.billing.associated_tenants
WHERE billingAccountName = '{{ billingAccountName }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.billing.associated_tenants (
associatedTenantName,
billingAccountName,
tags,
properties
)
SELECT 
'{{ associatedTenantName }}',
'{{ billingAccountName }}',
'{{ tags }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: tags
      value: object
    - name: properties
      value:
        - name: provisioningState
          value: string
        - name: displayName
          value: string
        - name: tenantId
          value: string
        - name: billingManagementState
          value: string
        - name: provisioningManagementState
          value: string
        - name: provisioningBillingRequestId
          value: string

DELETE example

Deletes the specified associated_tenants resource.

/*+ delete */
DELETE FROM azure.billing.associated_tenants
WHERE associatedTenantName = '{{ associatedTenantName }}'
AND billingAccountName = '{{ billingAccountName }}';