When creating the dataflow, we're connecting to ODBC (where dsn is defined for Athena). We return out AWS Catalog from Athena. But, when I try to return a single table from Athena with just two rows and four columns, the operation timed out after around 10 minutes. Here are the steps:Create new dataflowDefine new tables > add new tablesSelect ODBC as data sourceOn connection settings inpur the odbc connection string to bring up our athena connection, Nextower Query screen displays with a list of Athena catalog, select a table from one of the database. The display/preview screen keeps spinning. If I let this play out and wait for a preview, operation will time out here. But, we can select "Transform data" to proceed.If I proceed past the preview screen and wait, the operation eventually times out Just curious whether anyone has pointers/advice here? I am able to query this table in AWS Athena.

This issue was resolved by adding a PORT 444 inbound rule to our security group in AWS. https://aws.amazon.com/premiumsupport/knowledge-center/athena-connection-timeout-jdbc-odbc-driver/

catcollector

Helper I

5 years ago

Solved

DataFlow connect to Athena (ODBC) Timed out

When creating the dataflow, we're connecting to ODBC (where dsn is defined for Athena). We return out AWS Catalog from Athena. But, when I try to return a single table from Athena with just two rows and four columns, the operation timed out after around 10 minutes.

Here are the steps:

Create new dataflow
Define new tables > add new tables
Select ODBC as data source
On connection settings inpur the odbc connection string to bring up our athena connection, Next
ower Query screen displays with a list of Athena catalog, select a table from one of the database. The display/preview screen keeps spinning. If I let this play out and wait for a preview, operation will time out here. But, we can select "Transform data" to proceed.
If I proceed past the preview screen and wait, the operation eventually times out

Just curious whether anyone has pointers/advice here? I am able to query this table in AWS Athena.