10 Replies Latest reply on Jun 26, 2017 3:26 AM by Yuriy Fal

    Tableau Extract doing a sum query on the remote server

    Hristo Mitev



      is there a way to stop tableau from running this query on the remote server after it fetches the initial data?


      SELECT SUM(1) AS `COL`
      FROM `tablename` `table alias`
      HAVING COUNT(1)>0


      Surely there is a way for it to count everything internally and not burden the sql further with this query or are we doing something completely wrong?

      Any advice would be appreciated, since it seems 90% of the time spend doing extracts is executing this query.