You can configure how long the connector waits for connections to respond, and how often to reattempt establishing a connection, to help automate the connection process. To configure a connection with timeout and retries:
  1. Set the ConnectionTimeout property to amount of time, in seconds, that the connector should wait when establishing a connection before timing out the connection.
  2. Set the MaxErrorRetry property to the maximum number of times that the connector resubmits a failed request that can be retried, such as a 5xx error from the Athena server.
Example: Connection URL with basic proxy connection properties defined: 
jdbc:awsathena://AwsRegion=NA;User=1jt9Pcyq8pr3lvu143pfl4r86;Password=1jt9Pcyq8pr3lvu143pfl4r86;S3OutputLocation=SSE_S3;ConnectionTimeout=90;MaxErrorRetry=10;