Import Job - Access Module

Teradata® Tools and Utilities Access Module Reference

Product
Access Module
Release Number
17.00
Published
November 30, 2020
Language
English (United States)
Last Update
2020-11-18
dita:mapPath
sch1544831938749.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2425
lifecycle
previous
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 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’
         )
      );
   );
);