sql_pool_vulnerability_assessment_rule_baselines

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

Overview

Name	sql_pool_vulnerability_assessment_rule_baselines
Type	Resource
Id	azure.synapse.sql_pool_vulnerability_assessment_rule_baselines

Fields

The following fields are returned by SELECT queries:

get

Successfully got the vulnerability assessment rule baseline.

Name	Datatype	Description
properties	object	Resource properties.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	subscriptionId, resourceGroupName, workspaceName, sqlPoolName, vulnerabilityAssessmentName, ruleId, baselineName		Gets a SqlPool's vulnerability assessment rule baseline.
create_or_update	insert	subscriptionId, resourceGroupName, workspaceName, sqlPoolName, vulnerabilityAssessmentName, ruleId, baselineName		Creates or updates a Sql pool's vulnerability assessment rule baseline.
delete	delete	subscriptionId, resourceGroupName, workspaceName, sqlPoolName, vulnerabilityAssessmentName, ruleId, baselineName		Removes the database's vulnerability assessment rule baseline.

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.

Name	Datatype	Description
baselineName	string	The name of the vulnerability assessment rule baseline (default implies a baseline on a Sql pool level rule and master for workspace level rule).
resourceGroupName	string	The name of the resource group. The name is case insensitive.
ruleId	string	The vulnerability assessment rule ID.
sqlPoolName	string	SQL pool name
subscriptionId	string	The ID of the target subscription.
vulnerabilityAssessmentName	string	The name of the vulnerability assessment.
workspaceName	string	The name of the workspace.

SELECT examples

get

Gets a SqlPool's vulnerability assessment rule baseline.

SELECT
properties
FROM azure.synapse.sql_pool_vulnerability_assessment_rule_baselines
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND workspaceName = '{{ workspaceName }}' -- required
AND sqlPoolName = '{{ sqlPoolName }}' -- required
AND vulnerabilityAssessmentName = '{{ vulnerabilityAssessmentName }}' -- required
AND ruleId = '{{ ruleId }}' -- required
AND baselineName = '{{ baselineName }}' -- required
;

INSERT examples

create_or_update

Creates or updates a Sql pool's vulnerability assessment rule baseline.

INSERT INTO azure.synapse.sql_pool_vulnerability_assessment_rule_baselines (
data__properties,
subscriptionId,
resourceGroupName,
workspaceName,
sqlPoolName,
vulnerabilityAssessmentName,
ruleId,
baselineName
)
SELECT 
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ workspaceName }}',
'{{ sqlPoolName }}',
'{{ vulnerabilityAssessmentName }}',
'{{ ruleId }}',
'{{ baselineName }}'
RETURNING
properties
;

Manifest

# Description fields are for documentation purposes
- name: sql_pool_vulnerability_assessment_rule_baselines
  props:
    - name: subscriptionId
      value: string
      description: Required parameter for the sql_pool_vulnerability_assessment_rule_baselines resource.
    - name: resourceGroupName
      value: string
      description: Required parameter for the sql_pool_vulnerability_assessment_rule_baselines resource.
    - name: workspaceName
      value: string
      description: Required parameter for the sql_pool_vulnerability_assessment_rule_baselines resource.
    - name: sqlPoolName
      value: string
      description: Required parameter for the sql_pool_vulnerability_assessment_rule_baselines resource.
    - name: vulnerabilityAssessmentName
      value: string
      description: Required parameter for the sql_pool_vulnerability_assessment_rule_baselines resource.
    - name: ruleId
      value: string
      description: Required parameter for the sql_pool_vulnerability_assessment_rule_baselines resource.
    - name: baselineName
      value: string
      description: Required parameter for the sql_pool_vulnerability_assessment_rule_baselines resource.
    - name: properties
      value: object
      description: |
        Resource properties.

DELETE examples

delete

Removes the database's vulnerability assessment rule baseline.

DELETE FROM azure.synapse.sql_pool_vulnerability_assessment_rule_baselines
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND workspaceName = '{{ workspaceName }}' --required
AND sqlPoolName = '{{ sqlPoolName }}' --required
AND vulnerabilityAssessmentName = '{{ vulnerabilityAssessmentName }}' --required
AND ruleId = '{{ ruleId }}' --required
AND baselineName = '{{ baselineName }}' --required
;