subscriptions_aliases

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

Overview

Name	subscriptions_aliases
Type	Resource
Id	azure.billing.subscriptions_aliases

Fields

vw_subscriptions_aliases

Name	Datatype	Description
aliasName	text	field from the properties object
auto_renew	text	field from the properties object
beneficiary	text	field from the properties object
beneficiary_tenant_id	text	field from the properties object
billingAccountName	text	field from the properties object
billing_frequency	text	field from the properties object
billing_policies	text	field from the properties object
billing_profile_display_name	text	field from the properties object
billing_profile_id	text	field from the properties object
billing_profile_name	text	field from the properties object
billing_subscription_id	text	field from the properties object
consumption_cost_center	text	field from the properties object
customer_display_name	text	field from the properties object
customer_id	text	field from the properties object
customer_name	text	field from the properties object
display_name	text	field from the properties object
enrollment_account_display_name	text	field from the properties object
enrollment_account_id	text	field from the properties object
enrollment_account_subscription_details	text	field from the properties object
invoice_section_display_name	text	field from the properties object
invoice_section_id	text	field from the properties object
invoice_section_name	text	field from the properties object
last_month_charges	text	field from the properties object
month_to_date_charges	text	field from the properties object
next_billing_cycle_details	text	field from the properties object
offer_id	text	field from the properties object
operation_status	text	field from the properties object
product_category	text	field from the properties object
product_type	text	field from the properties object
product_type_id	text	field from the properties object
provisioning_state	text	field from the properties object
provisioning_tenant_id	text	field from the properties object
purchase_date	text	field from the properties object
quantity	text	field from the properties object
renewal_term_details	text	field from the properties object
reseller	text	field from the properties object
resource_uri	text	field from the properties object
sku_description	text	field from the properties object
sku_id	text	field from the properties object
status	text	field from the properties object
subscription_id	text	field from the properties object
suspension_reason_details	text	field from the properties object
suspension_reasons	text	field from the properties object
system_overrides	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 < > % & \ ? /
term_duration	text	field from the properties object
term_end_date	text	field from the properties object
term_start_date	text	field from the properties object

subscriptions_aliases

Name	Datatype	Description
properties	object	A billing subscription alias.
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	aliasName, billingAccountName	Gets a subscription by its alias ID. The operation is supported for seat based billing subscriptions.
list_by_billing_account	SELECT	billingAccountName	Lists the subscription aliases for a billing account. The operation is supported for seat based billing subscriptions.
create_or_update	INSERT	aliasName, billingAccountName	Creates or updates a billing subscription by its alias ID. The operation is supported for seat based billing subscriptions.

SELECT examples

Lists the subscription aliases for a billing account. The operation is supported for seat based billing subscriptions.

vw_subscriptions_aliases

SELECT
aliasName,
auto_renew,
beneficiary,
beneficiary_tenant_id,
billingAccountName,
billing_frequency,
billing_policies,
billing_profile_display_name,
billing_profile_id,
billing_profile_name,
billing_subscription_id,
consumption_cost_center,
customer_display_name,
customer_id,
customer_name,
display_name,
enrollment_account_display_name,
enrollment_account_id,
enrollment_account_subscription_details,
invoice_section_display_name,
invoice_section_id,
invoice_section_name,
last_month_charges,
month_to_date_charges,
next_billing_cycle_details,
offer_id,
operation_status,
product_category,
product_type,
product_type_id,
provisioning_state,
provisioning_tenant_id,
purchase_date,
quantity,
renewal_term_details,
reseller,
resource_uri,
sku_description,
sku_id,
status,
subscription_id,
suspension_reason_details,
suspension_reasons,
system_overrides,
tags,
term_duration,
term_end_date,
term_start_date
FROM azure.billing.vw_subscriptions_aliases
WHERE billingAccountName = '{{ billingAccountName }}';

subscriptions_aliases

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

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: tags
      value: object
    - name: properties
      value:
        - name: autoRenew
          value: string
        - name: beneficiaryTenantId
          value: string
        - name: beneficiary
          value:
            - name: tenantId
              value: string
            - name: objectId
              value: string
        - name: billingFrequency
          value: string
        - name: billingProfileId
          value: string
        - name: billingPolicies
          value: object
        - name: billingProfileDisplayName
          value: string
        - name: billingProfileName
          value: string
        - name: consumptionCostCenter
          value: string
        - name: customerId
          value: string
        - name: customerDisplayName
          value: string
        - name: customerName
          value: string
        - name: displayName
          value: string
        - name: enrollmentAccountId
          value: string
        - name: enrollmentAccountDisplayName
          value: string
        - name: enrollmentAccountSubscriptionDetails
          value:
            - name: enrollmentAccountStartDate
              value: string
            - name: subscriptionEnrollmentAccountStatus
              value: string
        - name: invoiceSectionId
          value: string
        - name: invoiceSectionDisplayName
          value: string
        - name: invoiceSectionName
          value: string
        - name: lastMonthCharges
          value:
            - name: currency
              value: string
            - name: value
              value: number
        - name: nextBillingCycleDetails
          value:
            - name: billingFrequency
              value: string
        - name: offerId
          value: string
        - name: productCategory
          value: string
        - name: productType
          value: string
        - name: productTypeId
          value: string
        - name: purchaseDate
          value: string
        - name: quantity
          value: integer
        - name: reseller
          value:
            - name: resellerId
              value: string
            - name: description
              value: string
        - name: renewalTermDetails
          value:
            - name: billingFrequency
              value: string
            - name: productId
              value: string
            - name: productTypeId
              value: string
            - name: skuId
              value: string
            - name: termDuration
              value: string
            - name: quantity
              value: integer
            - name: termEndDate
              value: string
        - name: skuId
          value: string
        - name: skuDescription
          value: string
        - name: systemOverrides
          value:
            - name: cancellation
              value: string
            - name: cancellationAllowedEndDate
              value: string
        - name: resourceUri
          value: string
        - name: termDuration
          value: string
        - name: termStartDate
          value: string
        - name: termEndDate
          value: string
        - name: provisioningTenantId
          value: string
        - name: status
          value: string
        - name: operationStatus
          value: string
        - name: provisioningState
          value: string
        - name: subscriptionId
          value: string
        - name: suspensionReasons
          value:
            - string
        - name: suspensionReasonDetails
          value:
            - - name: effectiveDate
                value: string
              - name: reason
                value: string
        - name: billingSubscriptionId
          value: string