Skip to main content

policies_by_customers

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

Overview

Namepolicies_by_customers
TypeResource
Idazure.billing.policies_by_customers

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, billingProfileName, customerNameUpdates the policies for a customer. This operation is supported only for billing accounts with agreement type Microsoft Partner 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.
customerNamestringThe ID that uniquely identifies a customer.

INSERT examples

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

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