linked_servers

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

Overview

Name	linked_servers
Type	Resource
Id	azure_isv.redis.linked_servers

Fields

vw_linked_servers

Name	Datatype	Description
name	text	field from the properties object
geo_replicated_primary_host_name	text	field from the properties object
linkedServerName	text	field from the properties object
linked_redis_cache_id	text	field from the properties object
linked_redis_cache_location	text	field from the properties object
primary_host_name	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
server_role	text	field from the properties object
subscriptionId	text	field from the properties object

linked_servers

Name	Datatype	Description
properties	object	Properties of a linked server to be returned in get/put response

Methods

Name	Accessible by	Required Params	Description
get	SELECT	linkedServerName, name, resourceGroupName, subscriptionId	Gets the detailed information about a linked server of a redis cache (requires Premium SKU).
list	SELECT	name, resourceGroupName, subscriptionId	Gets the list of linked servers associated with this redis cache (requires Premium SKU).
create	INSERT	linkedServerName, name, resourceGroupName, subscriptionId, data__properties	Adds a linked server to the Redis cache (requires Premium SKU).
delete	DELETE	linkedServerName, name, resourceGroupName, subscriptionId	Deletes the linked server from a redis cache (requires Premium SKU).

SELECT examples

Gets the list of linked servers associated with this redis cache (requires Premium SKU).

vw_linked_servers

SELECT
name,
geo_replicated_primary_host_name,
linkedServerName,
linked_redis_cache_id,
linked_redis_cache_location,
primary_host_name,
provisioning_state,
resourceGroupName,
server_role,
subscriptionId
FROM azure_isv.redis.vw_linked_servers
WHERE name = '{{ name }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

linked_servers

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

INSERT example

Use the following StackQL query and manifest file to create a new linked_servers resource.

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: linkedRedisCacheId
          value: string
        - name: linkedRedisCacheLocation
          value: string
        - name: serverRole
          value: string
        - name: geoReplicatedPrimaryHostName
          value: string
        - name: primaryHostName
          value: string

DELETE example

Deletes the specified linked_servers resource.

/*+ delete */
DELETE FROM azure_isv.redis.linked_servers
WHERE linkedServerName = '{{ linkedServerName }}'
AND name = '{{ name }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';