17.10 - Import 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 Azure Blob credentials file needs to be created and placed at $HOME/azureaxsmod.

DEFINE JOB IMPORT_TO_TERADATA
DESCRIPTION 'Import data to Teradata from Azure'
(

        SET TargetTable = 'AzureW001';

    STEP IMPORT_THE_DATA
    (
        APPLY $INSERT TO OPERATOR ($LOAD)
        SELECT * FROM OPERATOR ($FILE_READER ()
            ATTR
            (
                AccessModuleName = 'libazureaxsmod.so',
                AccessModuleInitStr = '-Container <ContainerName> -Prefix "<PrefixName>/" -Object testdata.raw -SinglePartFile True'
            )
        );

    );
);