Skip to main content

sql_migration_services_auth_keys

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

Overview

Namesql_migration_services_auth_keys
TypeResource
Idazure.data_migration.sql_migration_services_auth_keys

Fields

The following fields are returned by SELECT queries:

Successfully return of List Authentication Keys.

NameDatatypeDescription
authKey1stringThe first authentication key.
authKey2stringThe second authentication key.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectresourceGroupName, sqlMigrationServiceName, subscriptionIdRetrieve the List of Authentication Keys for Self Hosted Integration Runtime.

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
resourceGroupNamestringName of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
sqlMigrationServiceNamestringName of the SQL Migration Service.
subscriptionIdstringSubscription ID that identifies an Azure subscription.

SELECT examples

Retrieve the List of Authentication Keys for Self Hosted Integration Runtime.

SELECT
authKey1,
authKey2
FROM azure.data_migration.sql_migration_services_auth_keys
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND sqlMigrationServiceName = '{{ sqlMigrationServiceName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;