server_configuration_options

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

Overview

Name	server_configuration_options
Type	Resource
Id	azure.sql.server_configuration_options

Fields

vw_server_configuration_options

Name	Datatype	Description
managedInstanceName	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
serverConfigurationOptionName	text	field from the properties object
server_configuration_option_value	text	field from the properties object
subscriptionId	text	field from the properties object

server_configuration_options

Name	Datatype	Description
properties	object	The properties of server configuration option.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	managedInstanceName, resourceGroupName, serverConfigurationOptionName, subscriptionId	Gets managed instance server configuration option.
create_or_update	INSERT	managedInstanceName, resourceGroupName, serverConfigurationOptionName, subscriptionId	Updates managed instance server configuration option.

SELECT examples

Gets managed instance server configuration option.

vw_server_configuration_options

SELECT
managedInstanceName,
provisioning_state,
resourceGroupName,
serverConfigurationOptionName,
server_configuration_option_value,
subscriptionId
FROM azure.sql.vw_server_configuration_options
WHERE managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverConfigurationOptionName = '{{ serverConfigurationOptionName }}'
AND subscriptionId = '{{ subscriptionId }}';

server_configuration_options

SELECT
properties
FROM azure.sql.server_configuration_options
WHERE managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverConfigurationOptionName = '{{ serverConfigurationOptionName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.sql.server_configuration_options (
managedInstanceName,
resourceGroupName,
serverConfigurationOptionName,
subscriptionId,
properties
)
SELECT 
'{{ managedInstanceName }}',
'{{ resourceGroupName }}',
'{{ serverConfigurationOptionName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: serverConfigurationOptionValue
          value: integer
        - name: provisioningState
          value: string