Error while Loading Data into AWS S3 Athena using Foresight Connection

[AshokKumarBobbala]

Hi Team,

I am trying to load data into AWS S3 Athena using a Foresight connection in Alteryx and encountering the following error.

Workflow Tools Used: (Workflow Image attached)

• Input Data (In/Out)
• Select (Preparation)
• StreamIn (In-Database)

Error Message:

StreamIn (52) ERROR [HY000] [AmazonAthena][AthenaClientError]: ExceptionName: InvalidRequestException, ErrorType: 130, ExceptionMessage: Unable to verify/create output bucket aws-athena-query-results-0719165104-us-east-1¶OdbcException¶   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) ¶   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) ¶   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) ¶   at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) ¶   at org.ForeSight.Tools.Athena.ExecuteScalarQuery(String dsn, String query) ¶   at org.ForeSight.Tools.LakeFormation.GetStagingLocationUri(String odbcDsn, String prefix) ¶   at org.ForeSight.Alteryx.StreamInEngine.WriteData() ¶   at org.ForeSight.Alteryx.StreamInEngine.II_Close() ¶   at SRC.Alteryx.GenericIncomingConnectionHandler.II_Close(GenericIncomingConnectionHandler* )

Questions:

1. What does this error mean?
2. How can I resolve this issue and successfully load data into AWS S3 Athena using Foresight?

[ashleyharvey19]

I ran into a similar Athena load error after pushing data from Alteryx to S3 and it wasn’t obvious at first. For me the problem came down to schema mismatch and file format quirks. One column type didn’t match what Athena expected. After fixing the schema and regenerating files, queries finally ran clean. Logs helped more than the UI here.