- Schema:
BACKUP_
This Organization Usage view provides information on backup policies.
Columns¶
Organization-level columns
| Column Name | Data Type | Description |
|---|---|---|
| ORGANIZATION_NAME | VARCHAR | Name of the organization. |
| ACCOUNT_LOCATOR | VARCHAR | System-generated identifier for the account. |
| ACCOUNT_NAME | VARCHAR | User-defined identifier for the account. |
Additional columns
| Column name | Data type | Description |
|---|---|---|
| ID | NUMBER | Internal system-generated identifier for the backup policy. |
| NAME | VARCHAR | Name of the backup policy. |
| SCHEMA_ID | NUMBER | Internal system-generated identifier for the schema of the backup policy. |
| SCHEMA_NAME | VARCHAR | Schema that the backup policy belongs to. |
| CATALOG_ID | NUMBER | Internal system-generated identifier for the database of the backup policy. |
| CATALOG_NAME | VARCHAR | Database that the backup policy belongs to. |
| SCHEDULE | VARCHAR | Schedule for backup creation. |
| EXPIRE_AFTER_DAYS | NUMBER | Days after backup creation when backup should be expired. |
| HAS_RETENTION_LOCK | VARCHAR | Indicates whether the policy includes a retention lock. Y if policy has retention lock; N otherwise. Retention lock protects backups from being deleted by anyone for the defined retention period. The retention lock also prevents the retention period from being decreased on the policy. |
| OWNER | VARCHAR | Name of the role that owns the backup policy. |
| OWNER_ROLE_TYPE | VARCHAR | Type of role that owns the backup policy. Account role or Database role. |
| CREATED | TIMESTAMP_LTZ | Date and time when the backup policy was created. |
| LAST_ALTERED | TIMESTAMP_LTZ | Date and time when the backup policy was last altered. |
| DELETED | TIMESTAMP_LTZ | Date and time when the backup policy was deleted. |
| COMMENT | VARCHAR | Comment for the backup policy. |
Usage notes¶
- Latency for the view may be up to 180 minutes (3 hours).