sql_server_registrations

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

Overview

Name	sql_server_registrations
Type	Resource
Id	azure.azure_data.sql_server_registrations

Fields

vw_sql_server_registrations

Name	Datatype	Description
location	text	The geo-location where the resource lives
property_bag	text	field from the properties object
resourceGroupName	text	field from the properties object
resource_group	text	field from the properties object
sqlServerRegistrationName	text	field from the properties object
subscriptionId	text	field from the properties object
subscription_id	text	field from the properties object
system_data	text	field from the properties object
tags	text	Resource tags.

sql_server_registrations

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	The SQL server Registration properties.
systemData	object	Read only system data
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, sqlServerRegistrationName, subscriptionId	Gets a SQL Server registration.
list	SELECT	subscriptionId	Gets all SQL Server registrations in a subscription.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Gets all SQL Server registrations in a resource group.
create_or_update	INSERT	resourceGroupName, sqlServerRegistrationName, subscriptionId, data__location	Creates or updates a SQL Server registration.
delete	DELETE	resourceGroupName, sqlServerRegistrationName, subscriptionId	Deletes a SQL Server registration.
update	UPDATE	resourceGroupName, sqlServerRegistrationName, subscriptionId	Updates SQL Server Registration tags.

SELECT examples

Gets all SQL Server registrations in a subscription.

vw_sql_server_registrations

SELECT
location,
property_bag,
resourceGroupName,
resource_group,
sqlServerRegistrationName,
subscriptionId,
subscription_id,
system_data,
tags
FROM azure.azure_data.vw_sql_server_registrations
WHERE subscriptionId = '{{ subscriptionId }}';

sql_server_registrations

SELECT
location,
properties,
systemData,
tags
FROM azure.azure_data.sql_server_registrations
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.azure_data.sql_server_registrations (
resourceGroupName,
sqlServerRegistrationName,
subscriptionId,
data__location,
tags,
location,
properties
)
SELECT 
'{{ resourceGroupName }}',
'{{ sqlServerRegistrationName }}',
'{{ subscriptionId }}',
'{{ data__location }}',
'{{ tags }}',
'{{ location }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: tags
      value: object
    - name: location
      value: string
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: []
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedAt
          value: string
    - name: properties
      value:
        - name: subscriptionId
          value: string
        - name: resourceGroup
          value: string
        - name: propertyBag
          value: string

UPDATE example

Updates a sql_server_registrations resource.

/*+ update */
UPDATE azure.azure_data.sql_server_registrations
SET 
tags = '{{ tags }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}'
AND sqlServerRegistrationName = '{{ sqlServerRegistrationName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified sql_server_registrations resource.

/*+ delete */
DELETE FROM azure.azure_data.sql_server_registrations
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sqlServerRegistrationName = '{{ sqlServerRegistrationName }}'
AND subscriptionId = '{{ subscriptionId }}';