I did a research and it seems that the error might be caused by ODBC driver that AWS provides.
A similar error is documented in Amazon Forum thread below.
I recommend to make sure the correct drivers for your your Tableau Desktop version are installed from drivers page below.
Additionally, I recommend to review Amazon documentation below on how to configure Amazon Redshift ODBC Driver for Windows Operating system.
Hope this helps
Thank you for your reply!
I only get the error when I try to create an extract from a table with 500 millions rows. It works completely fine when I try to extract from a table with 50K rows.
Can this still be because of drivers?
Are you using custom SQL?
I've seen a similar error in the past and the error in the case reviewed was caused by a custom SQL dialog terminating with a semi-colon at the end of the SQL statement.
If custom SQL is not the case, opening a case with support will help initiate a deeper investigation
Please include the log files.
Please see "Sending Tableau Desktop Log Files" article for instructions on bundling and sending the files.