sql_pool_metadata_sync_configs

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

Overview

Name	sql_pool_metadata_sync_configs
Type	Resource
Id	azure.synapse.sql_pool_metadata_sync_configs

Fields

Name	Datatype	Description
properties	object	Metadata Sync Config properties

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, sqlPoolName, subscriptionId, workspaceName	Get the metadata sync configuration for a SQL pool
create	INSERT	resourceGroupName, sqlPoolName, subscriptionId, workspaceName	Set the metadata sync configuration for a SQL pool

SELECT examples

Get the metadata sync configuration for a SQL pool

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

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: enabled
          value: boolean
        - name: syncIntervalInMinutes
          value: integer