Export 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. The Teradata Access Module for Azure Blob credentials file needs to be created and placed at $HOME/azureaxsmod.

DEFINE JOB EXPORT_FROM_TERADATA
DESCRIPTION 'Export data from Teradata to Azure'
(
    STEP EXPORT_THE_DATA
    (
        APPLY TO OPERATOR ( $FILE_WRITER()
            ATTR
            (
                AccessModuleName = 'libazureaxsmod.so',
                AccessModuleInitStr = '-Container <ContainerName> -Prefix "<PrefixName>/" -Object testdata.raw -SinglePartFile True'
            )
        )
        SELECT * FROM OPERATOR ( $EXPORT
            ATTR
            (
                SelectStmt = 'SELECT * FROM AzureW001_src;'
            )
        );
    );
);