After establishing the connectivity from Athena to Qlik Sense, any attempt at selecting a table results in the operation not completing.
- Drivers were correctly installed and are up to date.
- Firewalls are allowing all required ports.
When creating a connection from AWS Athena ODBC and opening the data connection, databases and tables can be selected.
But after selecting a particular table, the page keeps "Spinning" and remains stuck in progress without a response. The option "insert Script" grey out as well.
Resolution
On Simba Athena ODBC driver DSN setup, there is one option called "Use Resultset Streaming".
Disable this option.