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

The following fields are returned by SELECT queries:

get_by_name

Name	Datatype	Description
location	string	Location of the workspace that contains this firewall rule.
properties	object	The properties representing the resource.
type	string	Type of resource this is.

list

Name	Datatype	Description
location	string	Location of the workspace that contains this firewall rule.
properties	object	The properties representing the resource.
type	string	Type of resource this is.

Methods

The following methods are available for this resource:

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

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
linkId	string	The ID of the replication link.
resourceGroupName	string	The name of the resource group. The name is case insensitive.
sqlPoolName	string	SQL pool name
subscriptionId	string	The ID of the target subscription.
workspaceName	string	The name of the workspace.

SELECT examples

get_by_name

Get SQL pool replication link by name.

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

list

Lists a Sql pool's replication links.

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