import_jobs
Creates, updates, deletes, gets or lists a import_jobs
resource.
Overview
Name | import_jobs |
Type | Resource |
Id | azure.storage_cache.import_jobs |
Fields
Name | Datatype | Description |
---|---|---|
location | string | The geo-location where the resource lives |
properties | object | Properties of the import job. |
tags | object | Resource tags. |
Methods
Name | Accessible by | Required Params | Description |
---|---|---|---|
get | SELECT | amlFilesystemName, importJobName, resourceGroupName, subscriptionId | Returns an import job. |
list_by_aml_filesystem | SELECT | amlFilesystemName, resourceGroupName, subscriptionId | Returns all import jobs the user has access to under an AML File System. |
create_or_update | INSERT | amlFilesystemName, importJobName, resourceGroupName, subscriptionId | Create or update an import job. Import jobs are automatically deleted 72 hours after completion. |
delete | DELETE | amlFilesystemName, importJobName, resourceGroupName, subscriptionId | Schedules an import job for deletion. |
update | UPDATE | amlFilesystemName, importJobName, resourceGroupName, subscriptionId | Update 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.
- All Properties
- Manifest
/*+ create */
INSERT INTO azure.storage_cache.import_jobs (
amlFilesystemName,
importJobName,
resourceGroupName,
subscriptionId,
tags,
location,
properties
)
SELECT
'{{ amlFilesystemName }}',
'{{ importJobName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ tags }}',
'{{ location }}',
'{{ properties }}'
;
- name: your_resource_model_name
props:
- name: tags
value: object
- name: location
value: string
- name: properties
value:
- name: provisioningState
value: string
- name: importPrefixes
value:
- string
- name: conflictResolutionMode
value: string
- name: maximumErrors
value: integer
- name: status
value:
- name: state
value: string
- name: statusMessage
value: string
- name: totalBlobsWalked
value: integer
- name: blobsWalkedPerSecond
value: integer
- name: totalBlobsImported
value: integer
- name: blobsImportedPerSecond
value: integer
- name: lastCompletionTime
value: string
- name: lastStartedTime
value: string
- name: totalErrors
value: integer
- name: totalConflicts
value: integer
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 }}';