Skip to main content

vw_sync_groups

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

Overview​

Namevw_sync_groups
TypeView
Idazure.sql.vw_sync_groups

Fields​

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

SQL Definition​

SELECT
sku as sku,
JSON_EXTRACT(properties, '$.interval') as "interval",
JSON_EXTRACT(properties, '$.lastSyncTime') as "last_sync_time",
JSON_EXTRACT(properties, '$.conflictResolutionPolicy') as "conflict_resolution_policy",
JSON_EXTRACT(properties, '$.syncDatabaseId') as "sync_database_id",
JSON_EXTRACT(properties, '$.hubDatabaseUserName') as "hub_database_user_name",
JSON_EXTRACT(properties, '$.hubDatabasePassword') as "hub_database_password",
JSON_EXTRACT(properties, '$.syncState') as "sync_state",
JSON_EXTRACT(properties, '$.schema') as "schema",
JSON_EXTRACT(properties, '$.enableConflictLogging') as "enable_conflict_logging",
JSON_EXTRACT(properties, '$.conflictLoggingRetentionInDays') as "conflict_logging_retention_in_days",
JSON_EXTRACT(properties, '$.usePrivateLinkConnection') as "use_private_link_connection",
JSON_EXTRACT(properties, '$.privateEndpointName') as "private_endpoint_name",
subscriptionId,
resourceGroupName,
serverName,
databaseName,
syncGroupName
FROM azure.sql.sync_groups
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND serverName = 'replace-me' AND databaseName = 'replace-me';