2 Replies Latest reply on Oct 3, 2018 8:46 AM by John Taylor

    Custom SQL in Extract executing when changing quick filters

    John Taylor

      I have a dashboard with a datasource that is MySQL connected to multiple tables, and one of the tables is Custom SQL because I have to decrypt fields that are in the MySQL db.

       

      I'm using an extract of this datasource, but it appears that Tableau is executing this very costly decrypt SQL over the entire datasource when I switch a quickfilter value.

       

      I thought these calculations were materialized at the time the extract is created?

       

      When I remove this table from the extract, the time it takes to switch a value in this quickfilter drops from 10 minutes to 5 seconds. (I verified in a performance recording that the costly procedure is the execution of a query)

       

      Any help appreciated, thanks !