sql_pool_vulnerability_assessments

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

Overview

Name	sql_pool_vulnerability_assessments
Type	Resource
Id	azure.synapse.sql_pool_vulnerability_assessments

Fields

vw_sql_pool_vulnerability_assessments

Name	Datatype	Description
recurring_scans	text	field from the properties object
resourceGroupName	text	field from the properties object
sqlPoolName	text	field from the properties object
storage_account_access_key	text	field from the properties object
storage_container_path	text	field from the properties object
storage_container_sas_key	text	field from the properties object
subscriptionId	text	field from the properties object
vulnerabilityAssessmentName	text	field from the properties object
workspaceName	text	field from the properties object

sql_pool_vulnerability_assessments

Name	Datatype	Description
properties	object	Properties of a Sql pool Vulnerability Assessment.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, sqlPoolName, subscriptionId, vulnerabilityAssessmentName, workspaceName	Gets the Sql pool's vulnerability assessment.
list	SELECT	resourceGroupName, sqlPoolName, subscriptionId, workspaceName	Lists the vulnerability assessment policies associated with a SQL pool.
create_or_update	INSERT	resourceGroupName, sqlPoolName, subscriptionId, vulnerabilityAssessmentName, workspaceName	Creates or updates the Sql pool vulnerability assessment.
delete	DELETE	resourceGroupName, sqlPoolName, subscriptionId, vulnerabilityAssessmentName, workspaceName	Removes the database's vulnerability assessment.

SELECT examples

Lists the vulnerability assessment policies associated with a SQL pool.

vw_sql_pool_vulnerability_assessments

SELECT
recurring_scans,
resourceGroupName,
sqlPoolName,
storage_account_access_key,
storage_container_path,
storage_container_sas_key,
subscriptionId,
vulnerabilityAssessmentName,
workspaceName
FROM azure.synapse.vw_sql_pool_vulnerability_assessments
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

sql_pool_vulnerability_assessments

SELECT
properties
FROM azure.synapse.sql_pool_vulnerability_assessments
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_vulnerability_assessments resource.

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: storageContainerPath
          value: string
        - name: storageContainerSasKey
          value: string
        - name: storageAccountAccessKey
          value: string
        - name: recurringScans
          value:
            - name: isEnabled
              value: boolean
            - name: emailSubscriptionAdmins
              value: boolean
            - name: emails
              value:
                - string

DELETE example

Deletes the specified sql_pool_vulnerability_assessments resource.

/*+ delete */
DELETE FROM azure.synapse.sql_pool_vulnerability_assessments
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND vulnerabilityAssessmentName = '{{ vulnerabilityAssessmentName }}'
AND workspaceName = '{{ workspaceName }}';