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'

) );

); );

1 REPLY
Teradata Employee

Re: Loading data from AWS S3 using TPT

The program requires a S3 URL but the domain in the URL is of apple not AWS.

 

An S3 URL starts with the Amazon region like "us-west-2" e.g. http://<s3-aws-region>.amazonaws.com/<bucket>. This is what the error message is about: Unable to set S3 parameter S3Region to "store-test"

 

For more details refer to: https://docs.aws.amazon.com/AmazonS3/latest/dev/UsingBucket.html