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_sql_database

An Azure SQL Database is an intelligent, scalable, relational database service built for the cloud.

Examples

Basic info

select
name,
id,
server_name,
location,
edition
from
azure_sql_database;

List databases that are not online

select
name,
id,
server_name,
location,
edition,
status
from
azure_sql_database
where
status != 'Online';

List databases that are not encrypted

select
name,
id,
server_name,
location,
edition,
transparent_data_encryption ->> 'status' as encryption_status
from
azure_sql_database
where
transparent_data_encryption ->> 'status' != 'Enabled';

.inspect azure_sql_database

Azure SQL Database

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
collationtextThe collation of the database.
containment_statebigintThe containment state of the database.
create_modejsonbSpecifies the mode of database creation.
creation_datetimestamp without time zoneThe creation date of the database.
current_service_objective_idtextThe current service level objective ID of the database.
database_idtextThe ID of the database.
default_secondary_locationtextThe default secondary region for this database.
earliest_restore_datetimestamp without time zoneThis records the earliest start date and time that restore is available for this database.
editiontextThe edition of the database.
elastic_pool_nametextThe name of the elastic pool the database is in.
failover_group_idtextThe resource identifier of the failover group containing this database.
idtextContains ID to identify a database uniquely.
kindtextKind of the database.
locationtextLocation of the database.
max_size_bytestextThe max size of the database expressed in bytes.
nametextThe friendly name that identifies the database.
read_scalejsonbReadScale indicates whether read-only connections are allowed to this database or not if the database is a geo-secondary.
recommended_indexjsonbThe recommended indices for this database.
recovery_services_recovery_point_resource_idtextSpecifies the resource ID of the recovery point to restore from if createMode is RestoreLongTermRetentionBackup.
regiontextThe Azure region/location in which the resource is located.
requested_service_objective_idtextThe configured service level objective ID of the database.
requested_service_objective_namejsonbThe name of the configured service level objective of the database.
resource_grouptextThe resource group which holds this resource.
restore_point_in_timetimestamp without time zoneSpecifies the point in time of the source database that will be restored to create the new database.
sample_namejsonbIndicates the name of the sample schema to apply when creating this database.
server_nametextThe name of the parent server of the database.
service_level_objectivejsonbThe current service level objective of the database.
service_tier_advisorsjsonbThe list of service tier advisors for this database.
source_database_deletion_datetimestamp without time zoneSpecifies the time that the database was deleted when createMode is Restore and sourceDatabaseId is the deleted database's original resource id.
source_database_idtextSpecifies the resource ID of the source database if createMode is Copy, NonReadableSecondary, OnlineSecondary, PointInTimeRestore, Recovery, or Restore.
statustextThe status of the database.
subscription_idtextThe Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
transparent_data_encryptionjsonbThe transparent data encryption info for this database.
typetextType of the database.
zone_redundantbooleanIndicates if the database is zone redundant or not.