Skip to main content

data_transfer_jobs

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

Overview

Namedata_transfer_jobs
TypeResource
Idazure.cosmos_db.data_transfer_jobs

Fields

The following fields are returned by SELECT queries:

The Data Transfer Job Properties retrieved successfully

NameDatatypeDescription
idstringThe unique resource identifier of the database account.
namestringThe name of the database account.
propertiesobjectThe properties of a DataTransfer Job
typestringThe type of Azure resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, accountName, jobNameGet a Data Transfer Job.
list_by_database_accountselectsubscriptionId, resourceGroupName, accountNameGet a list of Data Transfer jobs.
createinsertsubscriptionId, resourceGroupName, accountName, jobName, data__propertiesCreates a Data Transfer Job.
pauseexecsubscriptionId, resourceGroupName, accountName, jobNamePause a Data Transfer Job.
resumeexecsubscriptionId, resourceGroupName, accountName, jobNameResumes a Data Transfer Job.
cancelexecsubscriptionId, resourceGroupName, accountName, jobNameCancels a Data Transfer Job.
completeexecsubscriptionId, resourceGroupName, accountName, jobNameCompletes a Data Transfer Online Job.

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
accountNamestringCosmos DB database account name.
jobNamestringName of the Data Transfer Job
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstringThe ID of the target subscription.

SELECT examples

Get a Data Transfer Job.

SELECT
id,
name,
properties,
type
FROM azure.cosmos_db.data_transfer_jobs
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND accountName = '{{ accountName }}' -- required
AND jobName = '{{ jobName }}' -- required
;

INSERT examples

Creates a Data Transfer Job.

INSERT INTO azure.cosmos_db.data_transfer_jobs (
data__properties,
subscriptionId,
resourceGroupName,
accountName,
jobName
)
SELECT
'{{ properties }}' /* required */,
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ accountName }}',
'{{ jobName }}'
RETURNING
id,
name,
properties,
type
;

Lifecycle Methods

Pause a Data Transfer Job.

EXEC azure.cosmos_db.data_transfer_jobs.pause 
@subscriptionId='{{ subscriptionId }}' --required,
@resourceGroupName='{{ resourceGroupName }}' --required,
@accountName='{{ accountName }}' --required,
@jobName='{{ jobName }}' --required
;