vw_distributed_availability_groups

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

Overview

Name	vw_distributed_availability_groups
Type	View
Id	azure.sql.vw_distributed_availability_groups

Fields

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

SQL Definition

Sqlite3

SELECT
JSON_EXTRACT(properties, '$.targetDatabase') as "target_database",
JSON_EXTRACT(properties, '$.sourceEndpoint') as "source_endpoint",
JSON_EXTRACT(properties, '$.primaryAvailabilityGroupName') as "primary_availability_group_name",
JSON_EXTRACT(properties, '$.secondaryAvailabilityGroupName') as "secondary_availability_group_name",
JSON_EXTRACT(properties, '$.replicationMode') as "replication_mode",
JSON_EXTRACT(properties, '$.distributedAvailabilityGroupId') as "distributed_availability_group_id",
JSON_EXTRACT(properties, '$.sourceReplicaId') as "source_replica_id",
JSON_EXTRACT(properties, '$.targetReplicaId') as "target_replica_id",
JSON_EXTRACT(properties, '$.linkState') as "link_state",
JSON_EXTRACT(properties, '$.lastHardenedLsn') as "last_hardened_lsn",
subscriptionId,
resourceGroupName,
managedInstanceName,
distributedAvailabilityGroupName
FROM azure.sql.distributed_availability_groups
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND managedInstanceName = 'replace-me' AND distributedAvailabilityGroupName = 'replace-me';

Postgres

SELECT
json_extract_path_text(properties, '$.targetDatabase') as "target_database",
json_extract_path_text(properties, '$.sourceEndpoint') as "source_endpoint",
json_extract_path_text(properties, '$.primaryAvailabilityGroupName') as "primary_availability_group_name",
json_extract_path_text(properties, '$.secondaryAvailabilityGroupName') as "secondary_availability_group_name",
json_extract_path_text(properties, '$.replicationMode') as "replication_mode",
json_extract_path_text(properties, '$.distributedAvailabilityGroupId') as "distributed_availability_group_id",
json_extract_path_text(properties, '$.sourceReplicaId') as "source_replica_id",
json_extract_path_text(properties, '$.targetReplicaId') as "target_replica_id",
json_extract_path_text(properties, '$.linkState') as "link_state",
json_extract_path_text(properties, '$.lastHardenedLsn') as "last_hardened_lsn",
subscriptionId,
resourceGroupName,
managedInstanceName,
distributedAvailabilityGroupName
FROM azure.sql.distributed_availability_groups
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND managedInstanceName = 'replace-me' AND distributedAvailabilityGroupName = 'replace-me';