profiles

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

Overview

Name	profiles
Type	Resource
Id	azure.billing.profiles

Fields

vw_profiles

Name	Datatype	Description
bill_to	text	field from the properties object
billingAccountName	text	field from the properties object
billingProfileName	text	field from the properties object
billing_relationship_type	text	field from the properties object
currency	text	field from the properties object
current_payment_term	text	field from the properties object
display_name	text	field from the properties object
enabled_azure_plans	text	field from the properties object
has_read_access	text	field from the properties object
indirect_relationship_info	text	field from the properties object
invoice_day	text	field from the properties object
invoice_email_opt_in	text	field from the properties object
invoice_recipients	text	field from the properties object
other_payment_terms	text	field from the properties object
po_number	text	field from the properties object
provisioning_state	text	field from the properties object
ship_to	text	field from the properties object
sold_to	text	field from the properties object
spending_limit	text	field from the properties object
spending_limit_details	text	field from the properties object
status	text	field from the properties object
status_reason_code	text	field from the properties object
system_id	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 < > % & \ ? /
target_clouds	text	field from the properties object

profiles

Name	Datatype	Description
properties	object	A billing profile.
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	billingAccountName, billingProfileName	Gets a billing profile by its ID. The operation is supported for billing accounts with agreement type Microsoft Customer Agreement and Microsoft Partner Agreement.
list_by_billing_account	SELECT	billingAccountName	Lists the billing profiles that a user has access to. The operation is supported for billing accounts with agreement of type Microsoft Customer Agreement and Microsoft Partner Agreement.
create_or_update	INSERT	billingAccountName, billingProfileName	Creates or updates a billing profile. The operation is supported for billing accounts with agreement type Microsoft Customer Agreement and Microsoft Partner Agreement. If you are a MCA Individual (Pay-as-you-go) customer, then please use the Azure portal experience to create the billing profile.
delete	DELETE	billingAccountName, billingProfileName	Deletes a billing profile. The operation is supported for billing accounts with agreement type Microsoft Customer Agreement and Microsoft Partner Agreement.
validate_delete_eligibility	EXEC	billingAccountName, billingProfileName	Validates if the billing profile can be deleted. The operation is supported for billing accounts with agreement type Microsoft Customer Agreement and Microsoft Partner Agreement.

SELECT examples

Lists the billing profiles that a user has access to. The operation is supported for billing accounts with agreement of type Microsoft Customer Agreement and Microsoft Partner Agreement.

vw_profiles

SELECT
bill_to,
billingAccountName,
billingProfileName,
billing_relationship_type,
currency,
current_payment_term,
display_name,
enabled_azure_plans,
has_read_access,
indirect_relationship_info,
invoice_day,
invoice_email_opt_in,
invoice_recipients,
other_payment_terms,
po_number,
provisioning_state,
ship_to,
sold_to,
spending_limit,
spending_limit_details,
status,
status_reason_code,
system_id,
tags,
target_clouds
FROM azure.billing.vw_profiles
WHERE billingAccountName = '{{ billingAccountName }}';

profiles

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

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: tags
      value: object
    - name: properties
      value:
        - name: provisioningState
          value: string
        - name: billingRelationshipType
          value: string
        - name: billTo
          value: string
        - name: currency
          value: string
        - name: displayName
          value: string
        - name: enabledAzurePlans
          value:
            - - name: productId
                value: string
              - name: skuId
                value: string
              - name: skuDescription
                value: string
        - name: hasReadAccess
          value: boolean
        - name: indirectRelationshipInfo
          value: string
        - name: invoiceDay
          value: integer
        - name: invoiceEmailOptIn
          value: boolean
        - name: invoiceRecipients
          value:
            - string
        - name: poNumber
          value: string
        - name: shipTo
          value: string
        - name: soldTo
          value: string
        - name: spendingLimit
          value: string
        - name: spendingLimitDetails
          value:
            - - name: amount
                value: number
              - name: currency
                value: string
              - name: startDate
                value: string
              - name: endDate
                value: string
              - name: type
                value: string
              - name: status
                value: string
        - name: status
          value: string
        - name: statusReasonCode
          value: string
        - name: systemId
          value: string
        - name: tags
          value: object
        - name: targetClouds
          value:
            - string
        - name: currentPaymentTerm
          value: string
        - name: otherPaymentTerms
          value:
            - - name: term
                value: string
              - name: startDate
                value: string
              - name: endDate
                value: string
              - name: isDefault
                value: boolean

DELETE example

Deletes the specified profiles resource.

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