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'
) );
); );
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