Loading data from AWS S3 using TPT

Teradata Database on AWS
Enthusiast

Loading data from AWS S3 using TPT

Hi,

 

i am trying to load data into teradata table using AWS S3. I am running into below issue.

 

S3AXM [02143]: Error: Unable to set S3 parameter S3Region to "store-test": Failed on getaddrinfo() call, value=-2: Name or service not known

 

Can anyone please help in this regard?

 

My control file

 

DEFINE JOB IMPORT_TO_TERADATA

DESCRIPTION 'Import data to Teradata Amazon S3'

(

    SET TargetTable = 'media_stg.td_poc';

    STEP IMPORT_THE_DATA

    (

        APPLY $INSERT TO OPERATOR ($LOAD)

        SELECT * FROM OPERATOR ($FILE_READER ()

ATTR (

                AccessModuleName = 'libs3axsmod.so',

                AccessModuleInitStr = 'S3Bucket=http://store-test.blobstore.apple.com/teradatapoc S3Object=myfile S3SinglePartFile=True'

) );

); );