steampipe plugin install azure

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
cloud_environmenttextThe Azure Cloud Environment.
idtextContains ID to identify a table service uniquely
nametext=The friendly name that identifies the table service
regiontextThe Azure region/location in which the resource is located.
resource_grouptext=The resource group which holds this resource.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
storage_account_nametext=An unique read-only string that changes whenever the resource is updated
subscription_idtext=, !=, ~~, ~~*, !~~, !~~*The Azure Subscription ID in which the resource is located.
titletextTitle of the resource.
typetextType 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