Query: storage_account_blob_configurations

select
  blob_container_soft_delete_enabled  as "Blob Container Soft Delete Enabled",
  blob_container_soft_delete_retention_days as "Blob Container Soft Delete Detention Days",
  blob_restore_policy_enabled as "Blob Restore Policy Enabled",
  blob_restore_policy_days as "Blob Restore Policy Days",
  blob_versioning_enabled as "Blob Versioning Enabled",
  blob_change_feed_enabled as "Blob Change Feed Enabled",
  blob_soft_delete_retention_days as "Blob Soft Delete Retention Days"
from
  azure_storage_account
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);