sql_pool_replication_links

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

Overview

Name	sql_pool_replication_links
Type	Resource
Id	azure.synapse.sql_pool_replication_links

Fields

vw_sql_pool_replication_links

Name	Datatype	Description
is_termination_allowed	text	field from the properties object
linkId	text	field from the properties object
location	text	Location of the workspace that contains this firewall rule.
partner_database	text	field from the properties object
partner_location	text	field from the properties object
partner_role	text	field from the properties object
partner_server	text	field from the properties object
percent_complete	text	field from the properties object
replication_mode	text	field from the properties object
replication_state	text	field from the properties object
resourceGroupName	text	field from the properties object
role	text	field from the properties object
sqlPoolName	text	field from the properties object
start_time	text	field from the properties object
subscriptionId	text	field from the properties object
type	text	Type of resource this is.
workspaceName	text	field from the properties object

sql_pool_replication_links

Name	Datatype	Description
location	string	Location of the workspace that contains this firewall rule.
properties	object	Represents the properties of a Sql pool replication link.
type	string	Type of resource this is.

Methods

Name	Accessible by	Required Params	Description
get_by_name	SELECT	linkId, resourceGroupName, sqlPoolName, subscriptionId, workspaceName	Get SQL pool replication link by name.
list	SELECT	resourceGroupName, sqlPoolName, subscriptionId, workspaceName	Lists a Sql pool's replication links.

SELECT examples

Lists a Sql pool's replication links.

vw_sql_pool_replication_links

SELECT
is_termination_allowed,
linkId,
location,
partner_database,
partner_location,
partner_role,
partner_server,
percent_complete,
replication_mode,
replication_state,
resourceGroupName,
role,
sqlPoolName,
start_time,
subscriptionId,
type,
workspaceName
FROM azure.synapse.vw_sql_pool_replication_links
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

sql_pool_replication_links

SELECT
location,
properties,
type
FROM azure.synapse.sql_pool_replication_links
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';