Tableau Dashboard Performance Series : Tip#9: Custom SQL

Custom SQL can have a HUGE impact on the performance of your visuals for the live connections.

If you are using extracts, there will be no impact to the dashboard performance. But, for live connections, Custom SQL can be really deadly

Watch the clip from my youtube video about Custom SQL

Here is the full recording

Custom SQL can be a nightmare to troubleshoot as well

In general, my guidance is as follows

  1. AVOID at all costs if your analysis is LIVE against a data source
  2. AVOID at all costs if your analysis is querying a data source LIVE (oh, I guess I already said that above. Anyway, was worth repeating)
  3. In the case of extract option, the Custom SQL doesn’t affect your dashboard performance at all but it might impact your extract creation time

Published by

Lovekesh Babbar

Speaker on topics related to data, analytics and digital transformation