server_connection_policies

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

Overview

Name	server_connection_policies
Type	Resource
Id	azure.sql.server_connection_policies

Fields

vw_server_connection_policies

Name	Datatype	Description
connectionPolicyName	text	field from the properties object
connection_type	text	field from the properties object
kind	text	Metadata used for the Azure portal experience.
location	text	Resource location.
resourceGroupName	text	field from the properties object
serverName	text	field from the properties object
subscriptionId	text	field from the properties object

server_connection_policies

Name	Datatype	Description
kind	string	Metadata used for the Azure portal experience.
location	string	Resource location.
properties	object	The properties of a server connection policy.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	connectionPolicyName, resourceGroupName, serverName, subscriptionId	Gets a server connection policy
list_by_server	SELECT	resourceGroupName, serverName, subscriptionId	Lists connection policy
create_or_update	INSERT	connectionPolicyName, resourceGroupName, serverName, subscriptionId	Updates a server connection policy

SELECT examples

Lists connection policy

vw_server_connection_policies

SELECT
connectionPolicyName,
connection_type,
kind,
location,
resourceGroupName,
serverName,
subscriptionId
FROM azure.sql.vw_server_connection_policies
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

server_connection_policies

SELECT
kind,
location,
properties
FROM azure.sql.server_connection_policies
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.sql.server_connection_policies (
connectionPolicyName,
resourceGroupName,
serverName,
subscriptionId,
properties
)
SELECT 
'{{ connectionPolicyName }}',
'{{ resourceGroupName }}',
'{{ serverName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: location
      value: string
    - name: kind
      value: string
    - name: properties
      value:
        - name: connectionType
          value: string