workspace_managed_identity_sql_control_settings

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

Overview

Name	workspace_managed_identity_sql_control_settings
Type	Resource
Id	azure.synapse.workspace_managed_identity_sql_control_settings

Fields

Name	Datatype	Description
properties	object	Sql Control Settings for workspace managed identity

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, subscriptionId, workspaceName
create_or_update	INSERT	resourceGroupName, subscriptionId, workspaceName

SELECT examples

SELECT
properties
FROM azure.synapse.workspace_managed_identity_sql_control_settings
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.synapse.workspace_managed_identity_sql_control_settings (
resourceGroupName,
subscriptionId,
workspaceName,
properties
)
SELECT 
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ workspaceName }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: grantSqlControlToManagedIdentity
          value:
            - name: desiredState
              value: string
            - name: actualState
              value: string