Skip to main content

global_parameters

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

Overview

Nameglobal_parameters
TypeResource
Idazure.data_factory.global_parameters

Fields

The following fields are returned by SELECT queries:

OK.

NameDatatypeDescription
idstringThe resource identifier.
namestringThe resource name.
etagstringEtag identifies change in the resource.
propertiesobjectProperties of the global parameter.
typestringThe resource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, factoryName, globalParameterNameapi-versionGets a Global parameter
list_by_factoryselectsubscriptionId, resourceGroupName, factoryNameapi-versionLists Global parameters
create_or_updateinsertsubscriptionId, resourceGroupName, factoryName, globalParameterName, data__propertiesapi-versionCreates or updates a Global parameter
deletedeletesubscriptionId, resourceGroupName, factoryName, globalParameterNameapi-versionDeletes a Global parameter

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.

NameDatatypeDescription
factoryNamestringThe factory name.
globalParameterNamestringThe global parameter name.
resourceGroupNamestringThe resource group name.
subscriptionIdstringThe subscription identifier.
api-versionstringThe API version.

SELECT examples

Gets a Global parameter

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

INSERT examples

Creates or updates a Global parameter

INSERT INTO azure.data_factory.global_parameters (
data__properties,
subscriptionId,
resourceGroupName,
factoryName,
globalParameterName,
api-version
)
SELECT
'{{ properties }}' /* required */,
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ factoryName }}',
'{{ globalParameterName }}',
'{{ api-version }}'
RETURNING
id,
name,
etag,
properties,
type
;

DELETE examples

Deletes a Global parameter

DELETE FROM azure.data_factory.global_parameters
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND factoryName = '{{ factoryName }}' --required
AND globalParameterName = '{{ globalParameterName }}' --required
AND api-version = '{{ api-version }}'
;