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