v1.0 for Steampipe, Powerpipe, Flowpipe, 116 plugins, and 44 mods →

Plugins Mods Docs Home

turbot/azure

steampipe plugin install azuresteampipe plugin install azure

azure_alert_management azure_api_management azure_api_management_backend azure_app_configuration azure_app_service_environment azure_app_service_function_app azure_app_service_plan azure_app_service_web_app azure_app_service_web_app_slot azure_application_gateway azure_application_insight azure_application_security_group azure_automation_account azure_automation_variable azure_backup_policy azure_bastion_host azure_batch_account azure_cdn_frontdoor_profile azure_cognitive_account azure_compute_availability_set azure_compute_disk azure_compute_disk_access azure_compute_disk_encryption_set azure_compute_disk_metric_read_ops azure_compute_disk_metric_read_ops_daily azure_compute_disk_metric_read_ops_hourly azure_compute_disk_metric_write_ops azure_compute_disk_metric_write_ops_daily azure_compute_disk_metric_write_ops_hourly azure_compute_image azure_compute_resource_sku azure_compute_snapshot azure_compute_ssh_key azure_compute_virtual_machine azure_compute_virtual_machine_metric_available_memory azure_compute_virtual_machine_metric_available_memory_daily azure_compute_virtual_machine_metric_available_memory_hourly azure_compute_virtual_machine_metric_cpu_utilization azure_compute_virtual_machine_metric_cpu_utilization_daily azure_compute_virtual_machine_metric_cpu_utilization_hourly azure_compute_virtual_machine_scale_set azure_compute_virtual_machine_scale_set_network_interface azure_compute_virtual_machine_scale_set_vm azure_compute_virtual_machine_size azure_consumption_usage azure_container_group azure_container_registry azure_cosmosdb_account azure_cosmosdb_mongo_collection azure_cosmosdb_mongo_database azure_cosmosdb_restorable_database_account azure_cosmosdb_sql_database azure_data_factory azure_data_factory_dataset azure_data_factory_pipeline azure_data_lake_analytics_account azure_data_lake_store azure_data_protection_backup_job azure_data_protection_backup_vault azure_databox_edge_device azure_databricks_workspace azure_diagnostic_setting azure_dns_zone azure_eventgrid_domain azure_eventgrid_topic azure_eventhub_namespace azure_express_route_circuit azure_firewall azure_firewall_policy azure_frontdoor azure_hdinsight_cluster azure_healthcare_service azure_hpc_cache azure_hybrid_compute_machine azure_hybrid_kubernetes_connected_cluster azure_iothub azure_iothub_dps azure_key_vault azure_key_vault_certificate azure_key_vault_deleted_vault azure_key_vault_key azure_key_vault_key_version azure_key_vault_managed_hardware_security_module azure_key_vault_secret azure_kubernetes_cluster azure_kubernetes_service_version azure_kusto_cluster azure_lb azure_lb_backend_address_pool azure_lb_nat_rule azure_lb_outbound_rule azure_lb_probe azure_lb_rule azure_lighthouse_assignment azure_lighthouse_definition azure_location azure_log_alert azure_log_analytics_workspace azure_log_profile azure_logic_app_workflow azure_machine_learning_workspace azure_maintenance_configuration azure_management_group azure_management_lock azure_mariadb_server azure_monitor_activity_log_event azure_monitor_log_profile azure_mssql_elasticpool azure_mssql_managed_instance azure_mssql_virtual_machine azure_mysql_flexible_server azure_mysql_server azure_nat_gateway azure_network_interface azure_network_security_group azure_network_watcher azure_network_watcher_flow_log azure_policy_assignment azure_policy_definition azure_postgresql_flexible_server azure_postgresql_server azure_private_dns_zone azure_private_endpoint azure_provider azure_public_ip azure_recovery_services_backup_job azure_recovery_services_vault azure_redis_cache azure_resource azure_resource_group azure_resource_link azure_role_assignment azure_role_definition azure_route_table azure_search_service azure_security_center_auto_provisioning azure_security_center_automation azure_security_center_contact azure_security_center_jit_network_access_policy azure_security_center_setting azure_security_center_sub_assessment azure_security_center_subscription_pricing azure_service_fabric_cluster azure_servicebus_namespace azure_signalr_service azure_spring_cloud_service azure_sql_database azure_sql_server azure_storage_account azure_storage_blob azure_storage_blob_service azure_storage_container azure_storage_queue azure_storage_share_file azure_storage_sync azure_storage_table azure_storage_table_service azure_stream_analytics_job azure_subnet azure_subscription azure_synapse_workspace azure_tenant azure_virtual_network azure_virtual_network_gateway azure_web_application_firewall_policy

Table: azure_storage_table - Query Azure Storage Tables using SQL

Azure Storage Table is a service in Microsoft Azure that stores structured NoSQL data in the cloud, providing a key/attribute store with a schemaless design. Azure Table storage is now part of Azure Cosmos DB. Because Table storage is schemaless, it's easy to adapt your data as the needs of your application evolve.

Table Usage Guide

The azure_storage_table table provides insights into Azure Storage Tables within Microsoft Azure. As a DevOps engineer, explore table-specific details through this table, including metadata, resource group, and subscription. Utilize it to uncover information about tables, such as their properties, the resources they belong to, and the subscriptions they're part of.

Examples

Basic info

This query allows you to gain insights into your Azure storage tables, including their names, IDs, associated storage accounts, resource groups, regions, and subscription IDs. This can be particularly useful when assessing the organization and distribution of your storage resources across different Azure subscriptions and regions.

select
  name,
  id,
  storage_account_name,
  resource_group,
  region,
  subscription_id
from
  azure_storage_table;

select
  name,
  id,
  storage_account_name,
  resource_group,
  region,
  subscription_id
from
  azure_storage_table;

Schema for azure_storage_table

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
cloud_environment	text		The Azure Cloud Environment.
id	text		Contains ID to identify a table service uniquely
name	text	=	The friendly name that identifies the table service
region	text		The Azure region/location in which the resource is located.
resource_group	text	=	The resource group which holds this resource.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
storage_account_name	text	=	An unique read-only string that changes whenever the resource is updated
subscription_id	text	=, !=, ~~, ~~, !~~, !~~	The Azure Subscription ID in which the resource is located.
title	text		Title of the resource.
type	text		Type of the resource

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- azure

You can pass the configuration to the command with the --config argument:

steampipe_export_azure --config '<your_config>' azure_storage_table