When connecting to a DynamoDB table with Simba, it is limiting the amount of rows returned, anyone with an idea what could be causing this?

My table is containing over 8 million rows, but when connecting via Simba (ODBC) Tableau is only retrieving around 13K rows.

The rows that are returned are correct and it is possible to publish the data as a live connection. However, when trying to publish it as an extract it immediately fails with the following message:

"An error occurred when publishing the data source.

[SQLSTATE:58P01] Cannot create temp database: The transient database could not be created

Unable to create extract"

Would highly appreciate thoughts on what could be wrong!

Best,

Anton