steampipe plugin install azure

Table: azure_storage_table_service - Query Azure Storage Table Services using SQL

Azure Storage Table Service is a NoSQL datastore providing a key/attribute store with a schemaless design. This service allows you to store large amounts of structured data, providing a flexible schema for data. Azure Storage Table Services are ideal for storing structured, non-relational data.

Table Usage Guide

The azure_storage_table_service table provides insights into Azure Storage Table Services within Microsoft Azure. As a Data Engineer or Developer, you can explore service-specific details through this table, including properties, settings, and associated metadata. Utilize it to uncover information about table services, such as their properties, the storage account they belong to, and the configuration settings applied to them.

Examples

Basic info

Gain insights into the association between storage account names and their corresponding regions and resource groups. This information can be useful for managing resources and understanding the distribution of storage accounts across different regions and groups.

select
name,
storage_account_name,
region,
resource_group
from
azure_storage_table_service;
select
name,
storage_account_name,
region,
resource_group
from
azure_storage_table_service;

CORS rules info of each storage table service

Explore the Cross-Origin Resource Sharing (CORS) rules of your Azure Storage Table services. This query helps you understand the CORS configurations in place, including allowed headers, methods, origins, exposed headers, and the maximum age in seconds, providing insights into how your resources interact with requests from different origins.

select
name,
storage_account_name,
cors -> 'allowedHeaders' as allowed_headers,
cors -> 'allowedMethods' as allowed_methods,
cors -> 'allowedOrigins' as allowed_origins,
cors -> 'exposedHeaders' as exposed_eaders,
cors -> 'maxAgeInSeconds' as max_age_in_seconds
from
azure_storage_table_service,
jsonb_array_elements(cors_rules) as cors;
select
name,
storage_account_name,
json_extract(cors.value, '$.allowedHeaders') as allowed_headers,
json_extract(cors.value, '$.allowedMethods') as allowed_methods,
json_extract(cors.value, '$.allowedOrigins') as allowed_origins,
json_extract(cors.value, '$.exposedHeaders') as exposed_headers,
json_extract(cors.value, '$.maxAgeInSeconds') as max_age_in_seconds
from
azure_storage_table_service,
json_each(cors_rules) as cors;

Schema for azure_storage_table_service

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
cloud_environmenttextThe Azure Cloud Environment.
cors_rulesjsonbA list of CORS rules
idtextContains ID to identify a table service uniquely
nametextThe 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_service