17.10 - Export Job - Access Module

Teradata® Tools and Utilities Access Module Reference

Product
Access Module
Release Number
17.10
Published
October 2021
Language
English (United States)
Last Update
2021-11-02
dita:mapPath
uur1608578381725.ditamap
dita:ditavalPath
obe1474387269547.ditaval
The parameters inside <> brackets need to be replaced appropriately and <> brackets need to be removed. The Teradata Access Module for GCS credentials file needs to be created and placed at $HOME/.gcs.
DEFINE JOB EXPORT FROM TERADATA
DESCRIPTION 'Export data from Teradata to GCS'
(
   STEP EXPORT_THE_DATA
   (
      APPLY TO OPERATOR ($FILE_WRITER() 
        ATTR
        (
           AccessModuleName = 'libgcsaxsmod.so',
           AccessModuleInitStr = 'Bucket=<GCSBucketName>
                                  Prefix="<PrefixName>/"
                                  Object=testdata.raw’
        )
      )
      SELECT * FROM OPERATOR ($EXPORT() 
         ATTR
         (
            SelectStmt = 'SELECT * FROM GCSW001_src;'
         )
      );
   );
);