Table: aws_backup_vaults
This table shows data for Backup Vaults.
The primary key for this table is arn.
Relations
The following tables depend on aws_backup_vaults:
Columns
| Name | Type |
|---|---|
| _cq_id | uuid |
| _cq_parent_id | uuid |
| account_id | utf8 |
| region | utf8 |
| arn (PK) | utf8 |
| access_policy | json |
| notifications | json |
| tags | json |
| backup_vault_arn | utf8 |
| backup_vault_name | utf8 |
| creation_date | timestamp[us, tz=UTC] |
| creator_request_id | utf8 |
| encryption_key_arn | utf8 |
| lock_date | timestamp[us, tz=UTC] |
| locked | bool |
| max_retention_days | int64 |
| min_retention_days | int64 |
| number_of_recovery_points | int64 |
Example Queries
These SQL queries are sampled from CloudQuery policies and are compatible with PostgreSQL.
Vaults with no recovery points
WITH
"point" AS (SELECT DISTINCT vault_arn FROM aws_backup_vault_recovery_points)
SELECT
'Vaults with no recovery points' AS title,
vault.account_id,
vault.arn AS resource_id,
'fail' AS status
FROM
aws_backup_vaults AS vault LEFT JOIN "point" ON "point".vault_arn = vault.arn
WHERE
"point".vault_arn IS NULL;