2 Replies Latest reply: Nov 22, 2017 1:42 AM by Some Nath Roy RSS

    Issue to run Direct Query in Qlik Sense June 2017

    Some Nath Roy

      Hi All,

       

      I am trying to connect Greenplum database by using DIRECT QUERY.  The below error message is generating.

      ddq.PNG

       

      Have written the below DIRECT QUERY:

      Fact:

      DIRECT QUERY

      DIMENSION

      <field1>

       

      MEASURE

      <field2>

      FROM <schema_name>.<table_name>;

       

      But data is pulled successfully with the below select SQL:

      SQL Select

      <field1>,

      <field2>

      from <schema_name>.<table_name>;


      Does not Greenplum source support Direct Discovery ? Or Am I missing something?

       

      Thanks,

      Som