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;