2 Replies Latest reply on Jul 26, 2018 9:57 PM by kumar bharat

    Custom SQL Query Issue

    Benjamin Scheese

      Hello,

       

      I am trying to update the data preview in the data source pane but I keep receiving the following error:

      [Amazon][RedShift ODBC] (30) Error occurred while trying to execute a query: ERROR: syntax error at or near "1000" LINE 1: SELECT TOP 1000 1 AS "number of records", ^ (see image below).

       

       

      I am not sure what what to do from here, as I have tried different versions of the Amazon Redshift ODBC driver and nothing is working.

       

      Thanks