Skip to main content

import_jobs

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

Overview

Nameimport_jobs
TypeResource
Idaws.sesv2.import_jobs

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
completed_timestampstring (date-time)The time stamp of when the import job was completed.
created_timestampstring (date-time)The time stamp of when the import job was created.
failed_records_countintegerThe number of records that failed processing because of invalid input or other reasons.
failure_infoobjectThe failure details about an import job.
import_data_sourceobjectAn object that contains details about the data source of the import job.
import_destinationobjectAn object that contains details about the resource destination the import job is going to target.
job_idstringA string that represents a job ID.
job_statusstringThe status of the import job. (CREATED, PROCESSING, COMPLETED, FAILED, CANCELLED)
processed_records_countintegerThe current number of records processed.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_import_jobselectjob_id, regionProvides information about an import job.
list_import_jobsselectregionLists all of the import jobs.
create_import_jobinsertregion, ImportDestination, ImportDataSourceCreates an import job for a data destination.

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
job_idstringThe ID of the import job.
regionstringAWS region (default: us-east-1)

SELECT examples

Provides information about an import job.

SELECT
completed_timestamp,
created_timestamp,
failed_records_count,
failure_info,
import_data_source,
import_destination,
job_id,
job_status,
processed_records_count
FROM aws.sesv2.import_jobs
WHERE job_id = '{{ job_id }}' -- required
AND region = '{{ region }}' -- required
;

INSERT examples

Creates an import job for a data destination.

INSERT INTO aws.sesv2.import_jobs (
ImportDestination,
ImportDataSource,
region
)
SELECT
'{{ ImportDestination }}' /* required */,
'{{ ImportDataSource }}' /* required */,
'{{ region }}'
RETURNING
job_id
;