turbot/azure

steampipe plugin install azuresteampipe plugin install azure
On This Page
Get Involved

Table: azure_cosmosdb_account

Azure Cosmos DB is a fully managed NoSQL database service for modern app development.

Examples

List of database accounts where automatic failover is not enabled

select
name,
location,
enable_automatic_failover,
resource_group
from
azure_cosmosdb_account;

List of database accounts which allows traffic from all networks, including the public Internet.

select
name,
location,
virtual_network_rules
from
azure_cosmosdb_account
where
virtual_network_rules = '[]';

List of database accounts where multiple write location is not enabled

select
name,
location,
enable_multiple_write_locations
from
azure_cosmosdb_account
where
not enable_multiple_write_locations;

Failover policy info for the database accounts

select
name,
fp ->> 'failoverPriority' as failover_priority,
fp ->> 'locationName' as location_name
from
azure_cosmosdb_account
cross join jsonb_array_elements(failover_policies) as fp;

Consistency policy info for each account

select
name,
consistency_policy_max_interval,
consistency_policy_max_staleness_prefix,
database_account_offer_type,
default_consistency_level
from
azure_cosmosdb_account;

.inspect azure_cosmosdb_account

Azure Cosmos DB Account

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
capabilitiesjsonbA list of Cosmos DB capabilities for the account.
connector_offertextThe cassandra connector offer type for the Cosmos DB database C* account.
consistency_policy_max_intervalbigintThe time amount of staleness (in seconds) tolerated, when used with the Bounded Staleness consistency level.
consistency_policy_max_staleness_prefixbigintThe number of stale requests tolerated, when used with the Bounded Staleness consistency level.
corsjsonbA list of CORS policy for the Cosmos DB database account.
database_account_offer_typetextThe offer type for the Cosmos DB database account.
default_consistency_leveltextThe default consistency level and configuration settings of the Cosmos DB account.
disable_key_based_metadata_write_accessbooleanDisable write operations on metadata resources (databases, containers, throughput) via account keys.
document_endpointtextThe connection endpoint for the Cosmos DB database account.
enable_analytical_storagebooleanSpecifies whether to enable storage analytics, or not.
enable_automatic_failoverbooleanEnables automatic failover of the write region in the rare event that the region is unavailable due to an outage.
enable_cassandra_connectorbooleanEnables the cassandra connector on the Cosmos DB C* account.
enable_free_tierbooleanSpecifies whether free Tier is enabled for Cosmos DB database account, or not.
enable_multiple_write_locationsbooleanEnables the account to write in multiple locations.
failover_policiesjsonbA list of regions ordered by their failover priorities.
idtextContains ID to identify a database account uniquely.
ip_rulesjsonbA list of IP rules.
is_virtual_network_filter_enabledbooleanSpecifies whether to enable/disable Virtual Network ACL rules.
key_vault_key_uritextThe URI of the key vault, used to encrypt the Cosmos DB database account.
kindtextIndicates the type of database account.
locationsjsonbA list of all locations that are enabled for the Cosmos DB account.
nametextThe friendly name that identifies the database account.
private_endpoint_connectionsjsonbA list of Private Endpoint Connections configured for the Cosmos DB account.
provisioning_statetextThe provisioning state of the database account resource.
public_network_accesstextIndicates whether requests from Public Network are allowed.
read_locationsjsonbA list of read locations enabled for the Cosmos DB account.
regiontextThe Azure region/location in which the resource is located.
resource_grouptextThe resource group which holds this resource.
server_versiontextDescribes the ServerVersion of an a MongoDB account.
subscription_idtextThe Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
typetextType of the resource.
virtual_network_rulesjsonbA list of Virtual Network ACL rules configured for the Cosmos DB account.
write_locationsjsonbA list of write locations enabled for the Cosmos DB account.