Last Modified Date: 27 Feb 2017
- Tableau Desktop 8.0 and later versions
- DBQL Logs
ResolutionThe duplicate queries that appear in the DBQL logs are inherent to Teradata prepared statements.
Tableau 8.0 and later versions use ODBC to connect to Teradata databases.
When preparing a query Teradata parsed the query and build a query plan, which can take system resources. The Tableau ODBC protocol uses Teradata prepared statements for the following specific reasons:
- To check the syntactic validity of a query without executing it.
- To retrieve the metadata of a query without executing it, e.g. to get the names of all columns via "select * from <table>..."
- To retain a statement handle for supporting query cancellation at a later time.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials