Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email for assistance.

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Issue with publishing flows with Athena Connection to gallery

7 - Meteor



I have set up a DSN less connection to Amazon Athena and stored it on the gallery . If i try to build a connection using an input tool on my local machine it connects seamlessly to the data connection using the gallery and workflow runs fine. But if I publish it back to the gallery it throws an error as below:

  • Error SQLDriverConnect: [Simba][DriverIAMSupport] (8600) Connection Error: No AWS profile found: produser (Tool Id: 1)". I have the same version of the Simba Athena ODBC driver installed on server as well as local machine with AWS 

Can anyone please help ?




PS: I have used the connection string as per defined here : Troubleshooting AWS Athena Connections - Alteryx Community

16 - Nebula
16 - Nebula

@veekay123 Based on that error, I'm guessing that you're using the IAM Profile option in your DSN-less connection string. When you run that on your machine, it can find the AWS profile (see page 13 of this doc that talks about the credentials file location:%USERPROFILE%.awscredentials). When it runs on the server, the error means there was a problem finding that AWS profile/credentials file. You'll need to see what account is actually running the job and if that server has the AWS profile setup similar to your machine. 


Hopefully that points you in the right direction!

7 - Meteor

Thanks @patrick_digan . It is a valid point. I will check it out.