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'
)
);
);
);