The parameters inside <> brackets need to be replaced appropriately and <> brackets need to be removed. Teradata Access Module for GCS credentials file needs to be created and placed at $HOME/.gcs.
DEFINE JOB IMPORT_TO_TERADATA
DESCRIPTION 'Import data to Teradata from GCS'
(
SET TargetTable = 'GCSW001';
STEP IMPORT_THE_DATA
(
APPLY $INSERT TO OPERATOR ($LOAD)
SELECT * FROM OPERATOR ($FILE_READER ()
ATTR
(
AccessModuleName = 'libgcsaxsmod.so',
AccessModuleInitStr = 'Bucket=<GCSBucketName>
Prefix="<PrefixName>/"
Object=testdata.raw’
)
);
);
);