Skip to main content

credential_operations

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

Overview

Namecredential_operations
TypeResource
Idazure.data_factory.credential_operations

Fields

NameDatatypeDescription
idtextThe resource identifier.
nametextThe resource name.
descriptiontextfield from the properties object
annotationstextfield from the properties object
credentialNametextfield from the properties object
etagtextEtag identifies change in the resource.
factoryNametextfield from the properties object
resourceGroupNametextfield from the properties object
subscriptionIdtextfield from the properties object
typetextThe resource type.

Methods

NameAccessible byRequired ParamsDescription
getSELECTcredentialName, factoryName, resourceGroupName, subscriptionIdGets a credential.
list_by_factorySELECTfactoryName, resourceGroupName, subscriptionIdList credentials.
create_or_updateINSERTcredentialName, factoryName, resourceGroupName, subscriptionId, data__propertiesCreates or updates a credential.
deleteDELETEcredentialName, factoryName, resourceGroupName, subscriptionIdDeletes a credential.

SELECT examples

List credentials.

SELECT
id,
name,
description,
annotations,
credentialName,
etag,
factoryName,
resourceGroupName,
subscriptionId,
type
FROM azure.data_factory.vw_credential_operations
WHERE factoryName = '{{ factoryName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

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

DELETE example

Deletes the specified credential_operations resource.

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