Configuring Connection Timeouts and Retries

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;