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

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.
cors_rules	jsonb		A list of CORS rules
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_service