vw_ltr_backup_operations

Creates, updates, deletes, gets or lists a vw_ltr_backup_operations resource.

Overview

Name	vw_ltr_backup_operations
Type	View
Id	azure.postgresql.vw_ltr_backup_operations

Fields

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition

Sqlite3

SELECT
JSON_EXTRACT(properties, '$.datasourceSizeInBytes') as "datasource_size_in_bytes",
JSON_EXTRACT(properties, '$.dataTransferredInBytes') as "data_transferred_in_bytes",
JSON_EXTRACT(properties, '$.backupName') as "backup_name",
JSON_EXTRACT(properties, '$.backupMetadata') as "backup_metadata",
JSON_EXTRACT(properties, '$.status') as "status",
JSON_EXTRACT(properties, '$.startTime') as "start_time",
JSON_EXTRACT(properties, '$.endTime') as "end_time",
JSON_EXTRACT(properties, '$.percentComplete') as "percent_complete",
JSON_EXTRACT(properties, '$.errorCode') as "error_code",
JSON_EXTRACT(properties, '$.errorMessage') as "error_message",
subscriptionId,
resourceGroupName,
serverName,
backupName
FROM azure.postgresql.ltr_backup_operations
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND serverName = 'replace-me';

Postgres

SELECT
json_extract_path_text(properties, '$.datasourceSizeInBytes') as "datasource_size_in_bytes",
json_extract_path_text(properties, '$.dataTransferredInBytes') as "data_transferred_in_bytes",
json_extract_path_text(properties, '$.backupName') as "backup_name",
json_extract_path_text(properties, '$.backupMetadata') as "backup_metadata",
json_extract_path_text(properties, '$.status') as "status",
json_extract_path_text(properties, '$.startTime') as "start_time",
json_extract_path_text(properties, '$.endTime') as "end_time",
json_extract_path_text(properties, '$.percentComplete') as "percent_complete",
json_extract_path_text(properties, '$.errorCode') as "error_code",
json_extract_path_text(properties, '$.errorMessage') as "error_message",
subscriptionId,
resourceGroupName,
serverName,
backupName
FROM azure.postgresql.ltr_backup_operations
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND serverName = 'replace-me';