global_parameters

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

Overview

Name	global_parameters
Type	Resource
Id	azure.data_factory.global_parameters

Fields

vw_global_parameters

Name	Datatype	Description
id	text	The resource identifier.
name	text	The resource name.
etag	text	Etag identifies change in the resource.
factoryName	text	field from the properties object
globalParameterName	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
type	text	The resource type.

global_parameters

Name	Datatype	Description
id	string	The resource identifier.
name	string	The resource name.
etag	string	Etag identifies change in the resource.
properties	object	Global parameters associated with the Azure Data Factory
type	string	The resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	factoryName, globalParameterName, resourceGroupName, subscriptionId	Gets a Global parameter
list_by_factory	SELECT	factoryName, resourceGroupName, subscriptionId	Lists Global parameters
create_or_update	INSERT	factoryName, globalParameterName, resourceGroupName, subscriptionId, data__properties	Creates or updates a Global parameter
delete	DELETE	factoryName, globalParameterName, resourceGroupName, subscriptionId	Deletes a Global parameter

SELECT examples

Lists Global parameters

vw_global_parameters

SELECT
id,
name,
etag,
factoryName,
globalParameterName,
resourceGroupName,
subscriptionId,
type
FROM azure.data_factory.vw_global_parameters
WHERE factoryName = '{{ factoryName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

global_parameters

SELECT
id,
name,
etag,
properties,
type
FROM azure.data_factory.global_parameters
WHERE factoryName = '{{ factoryName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.data_factory.global_parameters (
factoryName,
globalParameterName,
resourceGroupName,
subscriptionId,
data__properties,
properties
)
SELECT 
'{{ factoryName }}',
'{{ globalParameterName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: etag
      value: string
    - name: properties
      value: []

DELETE example

Deletes the specified global_parameters resource.

/*+ delete */
DELETE FROM azure.data_factory.global_parameters
WHERE factoryName = '{{ factoryName }}'
AND globalParameterName = '{{ globalParameterName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';