Skip to main content

vw_database_accounts

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

Overview​

Namevw_database_accounts
TypeView
Idazure.cosmos_db.vw_database_accounts

Fields​

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

SQL Definition​

SELECT
id as id,
name as name,
location as location,
kind as kind,
identity as identity,
systemData as system_data,
type as type,
tags as tags,
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.documentEndpoint') as "document_endpoint",
JSON_EXTRACT(properties, '$.databaseAccountOfferType') as "database_account_offer_type",
JSON_EXTRACT(properties, '$.ipRules') as "ip_rules",
JSON_EXTRACT(properties, '$.isVirtualNetworkFilterEnabled') as "is_virtual_network_filter_enabled",
JSON_EXTRACT(properties, '$.enableAutomaticFailover') as "enable_automatic_failover",
JSON_EXTRACT(properties, '$.consistencyPolicy') as "consistency_policy",
JSON_EXTRACT(properties, '$.capabilities') as "capabilities",
JSON_EXTRACT(properties, '$.writeLocations') as "write_locations",
JSON_EXTRACT(properties, '$.readLocations') as "read_locations",
JSON_EXTRACT(properties, '$.locations') as "locations",
JSON_EXTRACT(properties, '$.failoverPolicies') as "failover_policies",
JSON_EXTRACT(properties, '$.virtualNetworkRules') as "virtual_network_rules",
JSON_EXTRACT(properties, '$.privateEndpointConnections') as "private_endpoint_connections",
JSON_EXTRACT(properties, '$.enableMultipleWriteLocations') as "enable_multiple_write_locations",
JSON_EXTRACT(properties, '$.enableCassandraConnector') as "enable_cassandra_connector",
JSON_EXTRACT(properties, '$.connectorOffer') as "connector_offer",
JSON_EXTRACT(properties, '$.disableKeyBasedMetadataWriteAccess') as "disable_key_based_metadata_write_access",
JSON_EXTRACT(properties, '$.keyVaultKeyUri') as "key_vault_key_uri",
JSON_EXTRACT(properties, '$.defaultIdentity') as "default_identity",
JSON_EXTRACT(properties, '$.publicNetworkAccess') as "public_network_access",
JSON_EXTRACT(properties, '$.enableFreeTier') as "enable_free_tier",
JSON_EXTRACT(properties, '$.apiProperties') as "api_properties",
JSON_EXTRACT(properties, '$.enableAnalyticalStorage') as "enable_analytical_storage",
JSON_EXTRACT(properties, '$.analyticalStorageConfiguration') as "analytical_storage_configuration",
JSON_EXTRACT(properties, '$.instanceId') as "instance_id",
JSON_EXTRACT(properties, '$.createMode') as "create_mode",
JSON_EXTRACT(properties, '$.restoreParameters') as "restore_parameters",
JSON_EXTRACT(properties, '$.backupPolicy') as "backup_policy",
JSON_EXTRACT(properties, '$.cors') as "cors",
JSON_EXTRACT(properties, '$.networkAclBypass') as "network_acl_bypass",
JSON_EXTRACT(properties, '$.networkAclBypassResourceIds') as "network_acl_bypass_resource_ids",
JSON_EXTRACT(properties, '$.diagnosticLogSettings') as "diagnostic_log_settings",
JSON_EXTRACT(properties, '$.disableLocalAuth') as "disable_local_auth",
JSON_EXTRACT(properties, '$.capacity') as "capacity",
JSON_EXTRACT(properties, '$.capacityMode') as "capacity_mode",
JSON_EXTRACT(properties, '$.capacityModeChangeTransitionState') as "capacity_mode_change_transition_state",
JSON_EXTRACT(properties, '$.enableMaterializedViews') as "enable_materialized_views",
JSON_EXTRACT(properties, '$.keysMetadata') as "keys_metadata",
JSON_EXTRACT(properties, '$.enablePartitionMerge') as "enable_partition_merge",
JSON_EXTRACT(properties, '$.enableBurstCapacity') as "enable_burst_capacity",
JSON_EXTRACT(properties, '$.minimalTlsVersion') as "minimal_tls_version",
JSON_EXTRACT(properties, '$.customerManagedKeyStatus') as "customer_managed_key_status",
JSON_EXTRACT(properties, '$.enablePriorityBasedExecution') as "enable_priority_based_execution",
JSON_EXTRACT(properties, '$.defaultPriorityLevel') as "default_priority_level",
JSON_EXTRACT(properties, '$.enablePerRegionPerPartitionAutoscale') as "enable_per_region_per_partition_autoscale",
subscriptionId,
resourceGroupName,
accountName
FROM azure.cosmos_db.database_accounts
WHERE subscriptionId = 'replace-me';