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:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
etagstring"If etag is provided in the response body, it may also be provided as a header per the normal etag convention. Entity tags are used for comparing two or more entities from the same requested resource. HTTP/1.1 uses entity tags in the etag (section 14.19), If-Match (section 14.24), If-None-Match (section 14.26), and If-Range (section 14.27) header fields.").
propertiesobjectProperties of the global parameter. Required.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, factory_name, global_parameter_name, subscription_idGets a Global parameter.
list_by_factoryselectresource_group_name, factory_name, subscription_idLists Global parameters.
create_or_updateinsertresource_group_name, factory_name, global_parameter_name, subscription_id, propertiesCreates or updates a Global parameter.
create_or_updatereplaceresource_group_name, factory_name, global_parameter_name, subscription_id, propertiesCreates or updates a Global parameter.
deletedeleteresource_group_name, factory_name, global_parameter_name, subscription_idDeletes 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
factory_namestringThe factory name. Required.
global_parameter_namestringThe global parameter name. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring

SELECT examples

Gets a Global parameter.

SELECT
id,
name,
etag,
properties,
systemData,
type
FROM azure.data_factory.global_parameters
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND factory_name = '{{ factory_name }}' -- required
AND global_parameter_name = '{{ global_parameter_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Creates or updates a Global parameter.

INSERT INTO azure.data_factory.global_parameters (
properties,
resource_group_name,
factory_name,
global_parameter_name,
subscription_id
)
SELECT
'{{ properties }}' /* required */,
'{{ resource_group_name }}',
'{{ factory_name }}',
'{{ global_parameter_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
etag,
properties,
systemData,
type
;

REPLACE examples

Creates or updates a Global parameter.

REPLACE azure.data_factory.global_parameters
SET
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND factory_name = '{{ factory_name }}' --required
AND global_parameter_name = '{{ global_parameter_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND properties = '{{ properties }}' --required
RETURNING
id,
name,
etag,
properties,
systemData,
type;

DELETE examples

Deletes a Global parameter.

DELETE FROM azure.data_factory.global_parameters
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND factory_name = '{{ factory_name }}' --required
AND global_parameter_name = '{{ global_parameter_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;