Skip to main content

import_jobs

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

Overview

Nameimport_jobs
TypeResource
Idazure.storage_cache.import_jobs

Fields

NameDatatypeDescription
locationstringThe geo-location where the resource lives
propertiesobjectProperties of the import job.
tagsobjectResource tags.

Methods

NameAccessible byRequired ParamsDescription
getSELECTamlFilesystemName, importJobName, resourceGroupName, subscriptionIdReturns an import job.
list_by_aml_filesystemSELECTamlFilesystemName, resourceGroupName, subscriptionIdReturns all import jobs the user has access to under an AML File System.
create_or_updateINSERTamlFilesystemName, importJobName, resourceGroupName, subscriptionIdCreate or update an import job. Import jobs are automatically deleted 72 hours after completion.
deleteDELETEamlFilesystemName, importJobName, resourceGroupName, subscriptionIdSchedules an import job for deletion.
updateUPDATEamlFilesystemName, importJobName, resourceGroupName, subscriptionIdUpdate an import job instance.

SELECT examples

Returns all import jobs the user has access to under an AML File System.

SELECT
location,
properties,
tags
FROM azure.storage_cache.import_jobs
WHERE amlFilesystemName = '{{ amlFilesystemName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

/*+ create */
INSERT INTO azure.storage_cache.import_jobs (
amlFilesystemName,
importJobName,
resourceGroupName,
subscriptionId,
tags,
location,
properties
)
SELECT
'{{ amlFilesystemName }}',
'{{ importJobName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ tags }}',
'{{ location }}',
'{{ properties }}'
;

UPDATE example

Updates a import_jobs resource.

/*+ update */
UPDATE azure.storage_cache.import_jobs
SET
tags = '{{ tags }}'
WHERE
amlFilesystemName = '{{ amlFilesystemName }}'
AND importJobName = '{{ importJobName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified import_jobs resource.

/*+ delete */
DELETE FROM azure.storage_cache.import_jobs
WHERE amlFilesystemName = '{{ amlFilesystemName }}'
AND importJobName = '{{ importJobName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';