Error "Unable to materialize temporary table" Joining Data Sources
Published: 31 Aug 2016 Last Modified Date: 13 Jan 2017
When joining across multiple data sources, the following error might occur:
Unable to materialize temporary table
Tableau Desktop 10.0.0
Work with your IT team to add exceptions to your antivirus software and Windows Defender. Note: Even if there is no antivirus software installed, Windows Defender may still be preventing the join from completing.
Navigate to C:\Program Files\Tableau\Tableau <VERSION>\bin for 64-bit version. Navigate to C:\Program Files (x86)\Tableau\Tableau <VERSION>\bin for 32-bit version.
Add the following files to the exceptions list within the antivirus software and Windows Defender:
Antivirus is preventing Tableau Desktop from working as expected.