Query: storage_account_blob_public_access

select
  'Blob Public Access' as label,
  case when allow_blob_public_access then 'Enabled' else 'Disabled' end as value,
  case when blob_soft_delete_enabled then 'alert' else 'ok' end as type
from
  azure_storage_account
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);