Import Job - Access Module

Teradata Tools and Utilities Access Module Reference

Product
Access Module
Release Number
16.10
Published
July 2017
Language
English (United States)
Last Update
2019-03-27
dita:mapPath
amk1499705096540.ditamap
dita:ditavalPath
amk1499705096540.ditaval
dita:id
B035-2425
lifecycle
previous
Product Category
Teradata Tools and Utilities
The parameters inside <> brackets need to be replaced appropriately and <> brackets need to be removed. Teradata Access Module for Amazon S3 config and credentials files need to be created and placed at $HOME/.aws.
DEFINE JOB IMPORT_TO_TERADATA
DESCRIPTION 'Import data to Teradata from Amazon S3'
(

    SET TargetTable = 'S3W001';

    STEP IMPORT_THE_DATA
    (
        APPLY $INSERT TO OPERATOR ($LOAD)
        SELECT * FROM OPERATOR ($FILE_READER ()
            ATTR
            (
                AccessModuleName = 'libs3axsmod.so',
                AccessModuleInitStr = 'S3Bucket=<S3BucketName>
S3Prefix="<PrefixName>/" S3Object=testdata.raw S3SinglePartFile=True'
            )
        );

    );
);