It looks like Tableau is doing something that the ODBC driver does not support. This is probably a limitation to the driver itself. Can you try creating a custom SQL instead?
Hi Ken, I had a conversation with my developer and he mentioned that the problem is with the one particular column in the table of type BIGINT. Seems unassigned BIGINT is no longer supported in SQL. The workaround is to cast the DocId to INTEGER. This resolved the issue.