Question

How to set up Athena query? (AmazonAthenaConnector)

  • 22 June 2022
  • 1 reply
  • 1 view
E
Badge

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
Rank
Badge +6

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


Community Stats

28,661
Posts
109,324
Replies
36,528
Members
Terms & ConditionsCookie 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.