firewall_rules

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

Overview

Name	firewall_rules
Type	Resource
Id	azure.maria_db.firewall_rules

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
properties	object	The properties of a firewall rule.

list_by_server

Name	Datatype	Description
properties	object	The properties of a firewall rule.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	subscriptionId, resourceGroupName, serverName, firewallRuleName		Gets information about a server firewall rule.
list_by_server	select	subscriptionId, resourceGroupName, serverName		List all the firewall rules in a given server.
create_or_update	insert	subscriptionId, resourceGroupName, serverName, firewallRuleName, data__properties		Creates a new firewall rule or updates an existing firewall rule.
delete	delete	subscriptionId, resourceGroupName, serverName, firewallRuleName		Deletes a server firewall rule.

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
firewallRuleName	string	The name of the server firewall rule.
resourceGroupName	string	The name of the resource group. The name is case insensitive.
serverName	string	The name of the server.
subscriptionId	string	The ID of the target subscription.

SELECT examples

get

Gets information about a server firewall rule.

SELECT
properties
FROM azure.maria_db.firewall_rules
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND serverName = '{{ serverName }}' -- required
AND firewallRuleName = '{{ firewallRuleName }}' -- required
;

list_by_server

List all the firewall rules in a given server.

SELECT
properties
FROM azure.maria_db.firewall_rules
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND serverName = '{{ serverName }}' -- required
;

INSERT examples

create_or_update

Creates a new firewall rule or updates an existing firewall rule.

INSERT INTO azure.maria_db.firewall_rules (
data__properties,
subscriptionId,
resourceGroupName,
serverName,
firewallRuleName
)
SELECT 
'{{ properties }}' /* required */,
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ serverName }}',
'{{ firewallRuleName }}'
RETURNING
properties
;

Manifest

# Description fields are for documentation purposes
- name: firewall_rules
  props:
    - name: subscriptionId
      value: string
      description: Required parameter for the firewall_rules resource.
    - name: resourceGroupName
      value: string
      description: Required parameter for the firewall_rules resource.
    - name: serverName
      value: string
      description: Required parameter for the firewall_rules resource.
    - name: firewallRuleName
      value: string
      description: Required parameter for the firewall_rules resource.
    - name: properties
      value: object
      description: |
        The properties of a firewall rule.

DELETE examples

delete

Deletes a server firewall rule.

DELETE FROM azure.maria_db.firewall_rules
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND serverName = '{{ serverName }}' --required
AND firewallRuleName = '{{ firewallRuleName }}' --required
;