turbot/azure

steampipe plugin install azuresteampipe plugin install azure
azure_ad_groupazure_ad_service_principalazure_ad_userazure_api_managementazure_app_service_environmentazure_app_service_function_appazure_app_service_planazure_app_service_web_appazure_application_security_groupazure_compute_availability_setazure_compute_diskazure_compute_disk_encryption_setazure_compute_disk_metric_read_opsazure_compute_disk_metric_read_ops_dailyazure_compute_disk_metric_read_ops_hourlyazure_compute_disk_metric_write_opsazure_compute_disk_metric_write_ops_dailyazure_compute_disk_metric_write_ops_hourlyazure_compute_imageazure_compute_resource_skuazure_compute_snapshotazure_compute_virtual_machineazure_compute_virtual_machine_metric_cpu_utilizationazure_compute_virtual_machine_metric_cpu_utilization_dailyazure_compute_virtual_machine_metric_cpu_utilization_hourlyazure_cosmosdb_accountazure_cosmosdb_mongo_databaseazure_cosmosdb_sql_databaseazure_data_factoryazure_data_factory_datasetazure_data_factory_pipelineazure_diagnostic_settingazure_express_route_circuitazure_firewallazure_key_vaultazure_key_vault_keyazure_key_vault_secretazure_kubernetes_clusterazure_locationazure_log_alertazure_log_profileazure_management_lockazure_mysql_serverazure_network_interfaceazure_network_security_groupazure_network_watcherazure_network_watcher_flow_logazure_policy_assignmentazure_policy_definitionazure_postgresql_serverazure_providerazure_public_ipazure_resource_groupazure_role_assignmentazure_role_definitionazure_route_tableazure_security_center_auto_provisioningazure_security_center_contactazure_security_center_settingazure_security_center_subscription_pricingazure_sql_databaseazure_sql_serverazure_storage_accountazure_storage_blobazure_storage_blob_serviceazure_storage_containerazure_storage_queueazure_storage_tableazure_storage_table_serviceazure_subnetazure_subscriptionazure_tenantazure_virtual_networkazure_virtual_network_gateway

Table: azure_cosmosdb_sql_database

Azure Cosmos DB is a global distributed, multi-model database that is used in a wide range of applications and use cases.

Examples

Basic info

select
name,
account_name,
database_users,
location,
resource_group
from
azure_cosmosdb_sql_database;

Database count per cosmosdb accounts

select
account_name,
count(name) as database_count
from
azure_cosmosdb_sql_database
group by
account_name;

List of sql databases without application tag key

select
name,
tags
from
azure_cosmosdb_sql_database
where
not tags :: JSONB ? 'application';

.inspect azure_cosmosdb_sql_database

Azure Cosmos DB SQL Database

NameTypeDescription
account_nametextThe friendly name that identifies the database account in which the database is created.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
autoscale_settings_max_throughputbigintContains maximum throughput, the resource can scale up to.
database_collstextA system generated property that specified the addressable path of the collections resource.
database_etagtextA system generated property representing the resource etag required for optimistic concurrency control.
database_idtextName of the Cosmos DB SQL database.
database_ridtextA system generated unique identifier for database.
database_tsbigintA system generated property that denotes the last updated timestamp of the resource.
database_userstextA system generated property that specifies the addressable path of the users resource.
idtextContains ID to identify a sql database uniquely.
nametextThe friendly name that identifies the sql database.
regiontextThe Azure region/location in which the resource is located.
resource_grouptextThe resource group which holds this resource.
subscription_idtextThe Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
throughputbigintContains the value of the Cosmos DB resource throughput or autoscaleSettings.
titletextTitle of the resource.
typetextType of the resource.