Error "Unable to materialize temporary table" Using Microsoft SQL Server Data Source With Multiple Joins
Published: 06 Oct 2016 Last Modified Date: 24 Aug 2022
Issue
When creating an Extract from a multiple join MS SQL data-source connection the following errors are returned:
Unable to materialize temporary table
or
Error materializing temporary table: EncodeString: bad argument
Environment
Tableau Desktop 10
MS SQL Server
Resolution
Make sure that there is a match between data type and content for each field used in the join.
Cause
Tableau creates a temporary table to materialize the join but finds a mismatch between data type and content for one or more fields, for example finding a 'Date' when a 'String' is expected.
Thank you for providing your feedback on the effectiveness of the article.