I've been using the connector as part of the Beta program, it's working fairly well.
Athena is not quite as user-friendly as a "true" relational database, and some of those rough edges get passed on through Tableau. You have to understand a bit more about what is happening underneath with the data in terms of typing, schema-on-read, SerDes, etc. But still very helpful.
There is another easy way to connect to AWS Athena. You can use a HTTP gateway to Athena Queries. What does that mean? It means every Athena query can be triggered using http get request and data can be streamed over HTTP or HTTPS to the client application. It's fairly easy. Check out this video that demonstrate it : AWS Athena over HTTP or HTTPs - [Instant Gateway Service] - YouTube
And then use Tableau Web Connector to extract the data (Web Data Connector )
Tableau has native connections to AWS Athena so anyone stumbling upon this look no further. Tableau fully supports AWS Athena. If you are looking to get started with Athena, this may be of interest. It automated the setup and optimization of data pipelines for Tableau users, including converting data to Apache Parquet format. https://blog.openbridge.com/aws-athena-automated-60-second-setup-zero-administration-and-automatic-optimization-eba474e9897a