KNOWLEDGE BASE

Error "Unable to materialize temporary table" Using Microsoft SQL Server Data Source With Multiple Joins


Published: 06 Oct 2016
Last Modified Date: 09 May 2017

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.
Did this article resolve the issue?