Query: cosmosdb_account_backup_policy

select
  backup_policy ->> 'type' as "Type",
  backup_policy -> 'periodicModeProperties' ->> 'backupIntervalInMinutes' as "Backup Interval - (minutes)",
  backup_policy -> 'periodicModeProperties' ->> 'backupRetentionIntervalInHours' as "Backup Retention Interval - (hours)",
  backup_policy -> 'periodicModeProperties' ->> 'backupStorageRedundancy' as "Backup Storage Redundancy"
from
  azure_cosmosdb_account
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);