Last Modified Date: 25 Sep 2019
ResolutionA best practice recommendation is to use the custom SQL statement to create a materialized view in the database, and then connect Tableau to that database view. This method streamlines the query and improves performance. When the database provides the query power, Tableau can focus on filtering and rendering the data provided by the database.
Custom SQL in the data connection can impact performance because Tableau issues the query to the database inside of a subquery.
Additional InformationBecause Custom SQL is sent to the database within a subquery, sometimes the same query can perform more quickly in the database's native query tool.
Materialized ViewA materialized view is a “select query” performed on the data source and the end result set is stored as a table in the database. The materialized view can be kept in sync with database updates.
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials