Skip to main content

policies_by_billing_profiles

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

Overview

Namepolicies_by_billing_profiles
TypeResource
Idazure.billing.policies_by_billing_profiles

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
create_or_updateinsertbillingAccountName, billingProfileNameUpdates the policies for a billing profile. This operation is supported only for billing accounts with agreement type Microsoft Customer Agreement.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
billingAccountNamestringThe ID that uniquely identifies a billing account.
billingProfileNamestringThe ID that uniquely identifies a billing profile.

INSERT examples

Updates the policies for a billing profile. This operation is supported only for billing accounts with agreement type Microsoft Customer Agreement.

INSERT INTO azure.billing.policies_by_billing_profiles (
data__tags,
data__properties,
billingAccountName,
billingProfileName
)
SELECT
'{{ tags }}',
'{{ properties }}',
'{{ billingAccountName }}',
'{{ billingProfileName }}'
RETURNING
properties,
tags
;