The parameters inside <> brackets need to be replaced appropriately and <> brackets need to be removed. The Teradata Access Module for S3 config file and credentials file need to be created and placed at $HOME/.aws.
DEFINE JOB EXPORT FROM TERADATA
DESCRIPTION 'Export data from Teradata to S3'
(
STEP EXPORT_THE_DATA
(
APPLY TO OPERATOR ($FILE_WRITER()
ATTR
(
AccessModuleName = 'libs3axsmod.so',
AccessModuleInitStr = 'S3Bucket=<S3BucketName>
S3Prefix="<PrefixName>/"
S3Object=testdata.raw’
S3SinglePartFile=True'
)
)
SELECT * FROM OPERATOR ($EXPORT()
ATTR
(
SelectStmt = 'SELECT * FROM S3W001_src;'
)
);
);
);