Error in IntelliJ and PyCharm UI when querying a Redshift Table

Answered

Using Intellij or PyCharm when clicking on a table name under the a schema to open a preview of the table yields the following error message (per the Services log):

_[2021-02-15 16:01:31] Connected
<schema>: <schema>, public, postgis> SELECT t.*, CTID
FROM <schema>.<table> t
LIMIT 501
[2021-02-15 16:01:31] [BO017] ERROR: ODBC Error (Redshift) - SQLPrepare failed: [<schema>-fdw] ODBC driver reported the following error during SQLExecute:
[2021-02-15 16:01:31] [<schema>-fdw] 42703:1:30:[Amazon][Amazon Redshift] (30) Error occurred while trying to execute a query: [SQLState 42703] ERROR: column "ctid" does not exist in labs_

It looks like the IntelliJ UI adds on a CTID column (which maps to a row identifier), suggesting a possible configuration issue for previewing <schema> datasets within the IntelliJ UI.

Is there a workaround available? 

This other issue from 2014 is the same https://intellij-support.jetbrains.com/hc/en-us/community/posts/206634755-Problems-editing-Redshift-tables

and another in 2017 https://youtrack.jetbrains.com/issue/DBE-458?_ga=2.133744718.1901208799.1615823110-1333647037.1615305289

1 comment
Comment actions Permalink

you've posted the same issue on our tracker, will continue investigation there.

0

Please sign in to leave a comment.