server_threat_protection_settings

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

Overview

Name	server_threat_protection_settings
Type	Resource
Id	azure.postgresql.server_threat_protection_settings

Fields

vw_server_threat_protection_settings

Name	Datatype	Description
creation_time	text	field from the properties object
resourceGroupName	text	field from the properties object
serverName	text	field from the properties object
state	text	field from the properties object
subscriptionId	text	field from the properties object
threatProtectionName	text	field from the properties object

server_threat_protection_settings

Name	Datatype	Description
properties	object	Properties of server Threat Protection state.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, serverName, subscriptionId, threatProtectionName	Get a server's Advanced Threat Protection settings.
list_by_server	SELECT	resourceGroupName, serverName, subscriptionId	Get a list of server's Threat Protection state.
create_or_update	INSERT	resourceGroupName, serverName, subscriptionId, threatProtectionName	Creates or updates a server's Advanced Threat Protection settings.

SELECT examples

Get a list of server's Threat Protection state.

vw_server_threat_protection_settings

SELECT
creation_time,
resourceGroupName,
serverName,
state,
subscriptionId,
threatProtectionName
FROM azure.postgresql.vw_server_threat_protection_settings
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

server_threat_protection_settings

SELECT
properties
FROM azure.postgresql.server_threat_protection_settings
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.postgresql.server_threat_protection_settings (
resourceGroupName,
serverName,
subscriptionId,
threatProtectionName,
properties
)
SELECT 
'{{ resourceGroupName }}',
'{{ serverName }}',
'{{ subscriptionId }}',
'{{ threatProtectionName }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: state
          value: string
        - name: creationTime
          value: string