Skip to main content

linked_servers

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

Overview

Namelinked_servers
TypeResource
Idazure_isv.redis.linked_servers

Fields

The following fields are returned by SELECT queries:

Response of get linked server.

NameDatatypeDescription
propertiesobjectProperties of the linked server.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresourceGroupName, name, linkedServerName, subscriptionIdGets the detailed information about a linked server of a redis cache (requires Premium SKU).
listselectresourceGroupName, name, subscriptionIdGets the list of linked servers associated with this redis cache (requires Premium SKU).
createinsertresourceGroupName, name, linkedServerName, subscriptionId, data__propertiesAdds a linked server to the Redis cache (requires Premium SKU).
deletedeleteresourceGroupName, name, linkedServerName, subscriptionIdDeletes the linked server from a redis cache (requires Premium SKU).

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.

NameDatatypeDescription
linkedServerNamestringThe name of the linked server that is being added to the Redis cache.
namestringThe name of the redis cache.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstringThe ID of the target subscription.

SELECT examples

Gets the detailed information about a linked server of a redis cache (requires Premium SKU).

SELECT
properties
FROM azure_isv.redis.linked_servers
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND name = '{{ name }}' -- required
AND linkedServerName = '{{ linkedServerName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;

INSERT examples

Adds a linked server to the Redis cache (requires Premium SKU).

INSERT INTO azure_isv.redis.linked_servers (
data__properties,
resourceGroupName,
name,
linkedServerName,
subscriptionId
)
SELECT
'{{ properties }}' /* required */,
'{{ resourceGroupName }}',
'{{ name }}',
'{{ linkedServerName }}',
'{{ subscriptionId }}'
RETURNING
properties
;

DELETE examples

Deletes the linked server from a redis cache (requires Premium SKU).

DELETE FROM azure_isv.redis.linked_servers
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND name = '{{ name }}' --required
AND linkedServerName = '{{ linkedServerName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
;