This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
On the Server machine, Alteryx Designer can read data connected to Amazon Athena, however the workflow never completes. Saving the workflow to the Gallery, the workflow never ends as well. No errors are displayed.
Amazon Athena ODBC Driver
ODBC Driver or AWS S3 Permissions issue.
Ensure the latest ODBC version is installed. Download from the Amazon AWS site. It's recommended to get the 64-bit version for optimal performance.
Enable logging via the ODBC DSN Setup window by clicking on the Logging Options button and set the level to LOG_DEBUG. Set the desired path to save the logs to. Examine the logs or consult your IT group or Amazon AWS Support for further assistance.
Note: These logging options must be set on the machine where the workflow is running from, which may include the Alteryx Server machine or any worker machines.
Possible errors that can be found in the logs concerning this kind of issue:
AOClient::LogGlueClientError: Error occur while calling Glue API GetCatalogImportStatus. Error detail: Athena Error No: 15, HTTP Response Code: 400, Exception Name: AccessDeniedException, Error Message: User: arn:aws:sts:: is not authorized to perform: glue:GetCatalogImportStatus on resource: arn:aws:glue::catalog