Import Job - Access Module

Teradata® Tools and Utilities Access Module Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Access Module
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2024-05-14
dita:mapPath
cya1691484517272.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
hjf1479308836950
lifecycle
latest
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 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 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'
         )
      );
   );
);