Skip to main content

vw_profiles

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

Overview​

Namevw_profiles
TypeView
Idazure.billing.vw_profiles

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, '$.billingRelationshipType') as "billing_relationship_type",
JSON_EXTRACT(properties, '$.billTo') as "bill_to",
JSON_EXTRACT(properties, '$.currency') as "currency",
JSON_EXTRACT(properties, '$.displayName') as "display_name",
JSON_EXTRACT(properties, '$.enabledAzurePlans') as "enabled_azure_plans",
JSON_EXTRACT(properties, '$.hasReadAccess') as "has_read_access",
JSON_EXTRACT(properties, '$.indirectRelationshipInfo') as "indirect_relationship_info",
JSON_EXTRACT(properties, '$.invoiceDay') as "invoice_day",
JSON_EXTRACT(properties, '$.invoiceEmailOptIn') as "invoice_email_opt_in",
JSON_EXTRACT(properties, '$.invoiceRecipients') as "invoice_recipients",
JSON_EXTRACT(properties, '$.poNumber') as "po_number",
JSON_EXTRACT(properties, '$.shipTo') as "ship_to",
JSON_EXTRACT(properties, '$.soldTo') as "sold_to",
JSON_EXTRACT(properties, '$.spendingLimit') as "spending_limit",
JSON_EXTRACT(properties, '$.spendingLimitDetails') as "spending_limit_details",
JSON_EXTRACT(properties, '$.status') as "status",
JSON_EXTRACT(properties, '$.statusReasonCode') as "status_reason_code",
JSON_EXTRACT(properties, '$.systemId') as "system_id",
JSON_EXTRACT(properties, '$.tags') as "tags",
JSON_EXTRACT(properties, '$.targetClouds') as "target_clouds",
JSON_EXTRACT(properties, '$.currentPaymentTerm') as "current_payment_term",
JSON_EXTRACT(properties, '$.otherPaymentTerms') as "other_payment_terms",
billingAccountName,
billingProfileName
FROM azure.billing.profiles
WHERE billingAccountName = 'replace-me';