05-31-2019 12:45 PM - edited 10-28-2022 04:20 PM
During the run time of workflow, the following error is received:
Error: Input Data (1): Error SQLExecute: [Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Athena Error No: 99, HTTP Response
Code: 1759505392, Error Message: Unable to connect to endpoint [Execution ID: e7fe279d-f39b-4872-b37d-8ad49d49f3f5]
In version 1.0.3 and greater of the ODBC Driver, Result Set Streaming is enabled by default which has extra requirements. More info on the requirements is here.
If connecting via a Connection String:
odbc:Driver={Simba Athena ODBC Driver};AwsRegion=[Region];S3OutputLocation=[S3Path];AuthenticationType=IAM Profile;AWSProfile=[
YourAccessKey];
PWD=[YourSecretKey];UseResultsetStreaming=0 OR (If using a Profile Name) odbc:Driver={Simba Athena ODBC Driver};AwsRegion=[Region];S3OutputLocation=[S3Path];AuthenticationType=IAM Profile;AWSProfile=[
YourProfileName]
;UseResultsetStreaming=0
If you are connecting to your Amazon Athena environment with a DSN connection (via ODBC Admin):
@TylerNg: You are awesome! After several calls with network team and AWS folks your comment and solution really saved my day! Thank you.
This solved my issue. Alteryx was freezing whenever connecting an input tool to Athena and data would not load from Athena. Those issues were resolved with this solution. Cheers!
This helped me so much! We have been back and forth with AWS support for weeks now and I just got my connection to work and return data. Thank you!