sql_pool_connection_policies

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

Overview

Name	sql_pool_connection_policies
Type	Resource
Id	azure.synapse.sql_pool_connection_policies

Fields

vw_sql_pool_connection_policies

Name	Datatype	Description
connectionPolicyName	text	field from the properties object
kind	text	Resource kind.
location	text	Resource location.
proxy_dns_name	text	field from the properties object
proxy_port	text	field from the properties object
redirection_state	text	field from the properties object
resourceGroupName	text	field from the properties object
security_enabled_access	text	field from the properties object
sqlPoolName	text	field from the properties object
state	text	field from the properties object
subscriptionId	text	field from the properties object
use_server_default	text	field from the properties object
visibility	text	field from the properties object
workspaceName	text	field from the properties object

sql_pool_connection_policies

Name	Datatype	Description
kind	string	Resource kind.
location	string	Resource location.
properties	object	Properties of a Sql pool connection policy.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	connectionPolicyName, resourceGroupName, sqlPoolName, subscriptionId, workspaceName	Get a Sql pool's connection policy, which is used with table auditing.

SELECT examples

Get a Sql pool's connection policy, which is used with table auditing.

vw_sql_pool_connection_policies

SELECT
connectionPolicyName,
kind,
location,
proxy_dns_name,
proxy_port,
redirection_state,
resourceGroupName,
security_enabled_access,
sqlPoolName,
state,
subscriptionId,
use_server_default,
visibility,
workspaceName
FROM azure.synapse.vw_sql_pool_connection_policies
WHERE connectionPolicyName = '{{ connectionPolicyName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

sql_pool_connection_policies

SELECT
kind,
location,
properties
FROM azure.synapse.sql_pool_connection_policies
WHERE connectionPolicyName = '{{ connectionPolicyName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';