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:
- What does this error mean?
- How can I resolve this issue and successfully load data into AWS S3 Athena using Foresight?
