Skip to main content

bill_of_materials_import_jobs

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

Overview

Namebill_of_materials_import_jobs
TypeResource
Idaws.supplychain.bill_of_materials_import_jobs

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
instance_idstringThe BillOfMaterialsImportJob instanceId. (pattern: <code>[a-f0-9]{8}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{12}</code>)
job_idstringThe BillOfMaterialsImportJob jobId. (pattern: <code>[a-f0-9]{8}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{12}</code>)
messagestringWhen the BillOfMaterialsImportJob has reached a terminal state, there will be a message.
s_3uristringThe S3 URI from which the CSV is read. (pattern: <code>[sS]3:​//[a-z0-9][a-z0-9.-]{1,61}[a-z0-9]/.+</code>)
statusstringThe BillOfMaterialsImportJob ConfigurationJobStatus. (NEW, FAILED, IN_PROGRESS, QUEUED, SUCCESS)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_bill_of_materials_import_jobselectinstance_id, job_id, regionGet status and details of a BillOfMaterialsImportJob.
create_bill_of_materials_import_jobinsertinstance_id, region, s3uriCreateBillOfMaterialsImportJob creates an import job for the Product Bill Of Materials (BOM) entity. For information on the product_bom entity, see the AWS Supply Chain User Guide. The CSV file must be located in an Amazon S3 location accessible to AWS Supply Chain. It is recommended to use the same Amazon S3 bucket created during your AWS Supply Chain instance creation.

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
instance_idstringThe AWS Supply Chain instance identifier.
job_idstringThe BillOfMaterialsImportJob identifier.
regionstringAWS region (default: us-east-1)

SELECT examples

Get status and details of a BillOfMaterialsImportJob.

SELECT
instance_id,
job_id,
message,
s_3uri,
status
FROM aws.supplychain.bill_of_materials_import_jobs
WHERE instance_id = '{{ instance_id }}' -- required
AND job_id = '{{ job_id }}' -- required
AND region = '{{ region }}' -- required
;

INSERT examples

CreateBillOfMaterialsImportJob creates an import job for the Product Bill Of Materials (BOM) entity. For information on the product_bom entity, see the AWS Supply Chain User Guide. The CSV file must be located in an Amazon S3 location accessible to AWS Supply Chain. It is recommended to use the same Amazon S3 bucket created during your AWS Supply Chain instance creation.

INSERT INTO aws.supplychain.bill_of_materials_import_jobs (
s3uri,
clientToken,
instance_id,
region
)
SELECT
'{{ s3uri }}' /* required */,
'{{ clientToken }}',
'{{ instance_id }}',
'{{ region }}'
RETURNING
job_id
;