Skip to main content

workspace_managed_sql_server_dedicated_sql_minimal_tls_settings

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

Overview

Nameworkspace_managed_sql_server_dedicated_sql_minimal_tls_settings
TypeResource
Idazure.synapse.workspace_managed_sql_server_dedicated_sql_minimal_tls_settings

Fields

The following fields are returned by SELECT queries:

Successfully retrieved dedicated sql minimal tls settings.

NameDatatypeDescription
locationstringResource location.
propertiesobjectResource properties.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, workspaceName, dedicatedSQLminimalTlsSettingsNameGet workspace managed sql server's minimal tls settings.
listselectsubscriptionId, resourceGroupName, workspaceNameList workspace managed sql server's minimal tls settings.
updatereplacesubscriptionId, resourceGroupName, workspaceName, dedicatedSQLminimalTlsSettingsNameUpdate workspace managed sql server's minimal tls settings.

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
dedicatedSQLminimalTlsSettingsNamestringThe name of the dedicated sql minimal tls settings.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstringThe ID of the target subscription.
workspaceNamestringThe name of the workspace.

SELECT examples

Get workspace managed sql server's minimal tls settings.

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

REPLACE examples

Update workspace managed sql server's minimal tls settings.

REPLACE azure.synapse.workspace_managed_sql_server_dedicated_sql_minimal_tls_settings
SET
data__properties = '{{ properties }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND workspaceName = '{{ workspaceName }}' --required
AND dedicatedSQLminimalTlsSettingsName = '{{ dedicatedSQLminimalTlsSettingsName }}' --required
RETURNING
location,
properties;