Table: azure_storage_blob_services

This table shows data for Azure Storage Blob Services.

https://learn.microsoft.com/en-us/rest/api/storagerp/blob-services/list?tabs=HTTP#blobserviceproperties (opens in a new tab)

The primary key for this table is id.

Relations

This table depends on azure_storage_accounts.

Columns

NameType
_cq_iduuid
_cq_parent_iduuid
subscription_idutf8
propertiesjson
id (PK)utf8
nameutf8
skujson
typeutf8

Example Queries

These SQL queries are sampled from CloudQuery policies and are compatible with PostgreSQL.

Ensure soft delete is enabled for Azure Storage

SELECT
  'Ensure soft delete is enabled for Azure Storage' AS title,
  subscription_id AS subscription_id,
  id AS resource_id,
  CASE
  WHEN (properties->'deleteRetentionPolicy'->>'enabled')::BOOL THEN 'pass'
  ELSE 'fail'
  END
    AS status
FROM
  azure_storage_blob_services;