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;

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