Skip to main content
Question

How to set up Athena query? (AmazonAthenaConnector)

  • June 22, 2022
  • 1 reply
  • 19 views
E
Forum|alt.badge.img

Hi all,

I'm trying to use the AmazonAthenaConnector but I'm not sure what the correct settings are.

 

imageFirstly, what do I need to put in the Bucket / Path fields?

 

Secondly - when I try adding values in these field and run the translation I'm getting the following error:

 

Invalid bucket name "all-product-athena-result/": Bucket name must match the regex "^[a-zA-Z0-9.\\-_]{1,255}$"

Error encountered while calling method `input'

AmazonAthenaConnector_2_CALLER (PythonFactory): PythonFactory failed to process feature

 

Thanks,

Ed

 

 

1 reply

JennaKAtSafe
Safer
Forum|alt.badge.img+8

Hi @edhere. The Bucket and Path are highlighted in red meaning they are required parameters. Looking at the documentation for the AmazonAthenaConnector the bucket and path is used to save the results of the query.  Looks like you should be able to navigate to the AWS S3 console and click on your bucket's name to find this. Hope this points you in the right direction!

Reply


Helpful Members This Week

Community Stats

31,662
Posts
120,086
Replies
39,311
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.