Timesteam Athena Connector - Extremely poor performance

Hi,

We are currently investigating the use of the Timestream Athena connector (https://docs.aws.amazon.com/athena/latest/ug/connectors-timestream.html) as a way of enabling our data teams to work with new time series data alongside existing S3 datalake and warehouse data.

Despite setting up the connector as described here (and having this configuration sanity-checked by several engineers), I am unable to yield any kind of reasonable response time from this connector approach.

The below screenshot shows an example of a very simple query to Timestream running through the connector (via Athena query editor). You can see it takes over 5 minutes to return just a single row. The same query, running through the Timestream query editor, is almost instant (as one would expect).

Whilst I fully understand there will be some degradation of query performance by going through Athena, this is obviously not within "reasonable tolerances". I have deployed the connector using the AWS console approach as described in the documentation, so the configuration of this connector should be "as it comes".

Any help would be greatly appreciated.