Skip to main content

vw_accounts

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

Overview​

Namevw_accounts
TypeView
Idazure.billing.vw_accounts

Fields​

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition​

SELECT
tags as tags,
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.accountStatus') as "account_status",
JSON_EXTRACT(properties, '$.accountType') as "account_type",
JSON_EXTRACT(properties, '$.accountSubType') as "account_sub_type",
JSON_EXTRACT(properties, '$.accountStatusReasonCode') as "account_status_reason_code",
JSON_EXTRACT(properties, '$.agreementType') as "agreement_type",
JSON_EXTRACT(properties, '$.displayName') as "display_name",
JSON_EXTRACT(properties, '$.enrollmentDetails') as "enrollment_details",
JSON_EXTRACT(properties, '$.hasReadAccess') as "has_read_access",
JSON_EXTRACT(properties, '$.hasNoBillingProfiles') as "has_no_billing_profiles",
JSON_EXTRACT(properties, '$.notificationEmailAddress') as "notification_email_address",
JSON_EXTRACT(properties, '$.primaryBillingTenantId') as "primary_billing_tenant_id",
JSON_EXTRACT(properties, '$.soldTo') as "sold_to",
JSON_EXTRACT(properties, '$.registrationNumber') as "registration_number",
JSON_EXTRACT(properties, '$.billingRelationshipTypes') as "billing_relationship_types",
JSON_EXTRACT(properties, '$.qualifications') as "qualifications",
JSON_EXTRACT(properties, '$.taxIds') as "tax_ids",
billingAccountName
FROM azure.billing.accounts
WHERE billingAccountName = 'replace-me';