Skip to main content

role_assignments_by_departments

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

Overview

Namerole_assignments_by_departments
TypeResource
Idazure.billing.role_assignments_by_departments

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, departmentName, billingRoleAssignmentNameCreate or update a billing role assignment. The operation is supported only for billing accounts with agreement type Enterprise 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.
billingRoleAssignmentNamestringThe ID that uniquely identifies a role assignment.
departmentNamestringThe name of the department.

INSERT examples

Create or update a billing role assignment. The operation is supported only for billing accounts with agreement type Enterprise Agreement.

INSERT INTO azure.billing.role_assignments_by_departments (
data__tags,
data__properties,
billingAccountName,
departmentName,
billingRoleAssignmentName
)
SELECT
'{{ tags }}',
'{{ properties }}',
'{{ billingAccountName }}',
'{{ departmentName }}',
'{{ billingRoleAssignmentName }}'
RETURNING
properties,
tags
;