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

vw_sql_pool_vulnerability_assessment_rule_baselines

Name	Datatype	Description
baselineName	text	field from the properties object
baseline_results	text	field from the properties object
resourceGroupName	text	field from the properties object
ruleId	text	field from the properties object
sqlPoolName	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_assessment_rule_baselines

Name	Datatype	Description
properties	object	Properties of a Sql pool vulnerability assessment rule baseline.

Methods

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

SELECT examples

Gets a SqlPool's vulnerability assessment rule baseline.

vw_sql_pool_vulnerability_assessment_rule_baselines

SELECT
baselineName,
baseline_results,
resourceGroupName,
ruleId,
sqlPoolName,
subscriptionId,
vulnerabilityAssessmentName,
workspaceName
FROM azure.synapse.vw_sql_pool_vulnerability_assessment_rule_baselines
WHERE baselineName = '{{ baselineName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND ruleId = '{{ ruleId }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND vulnerabilityAssessmentName = '{{ vulnerabilityAssessmentName }}'
AND workspaceName = '{{ workspaceName }}';

sql_pool_vulnerability_assessment_rule_baselines

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

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: baselineResults
          value:
            - - name: result
                value:
                  - string

DELETE example

Deletes the specified sql_pool_vulnerability_assessment_rule_baselines resource.

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