5 Replies Latest reply on Jan 12, 2017 2:24 PM by Russell Christopher

    Unable to materialize temporary table on multi-data source

    Wes Gelpi

      I have a workbook that is leveraging two different data sources:

       

      1.      Google Sheets
      2.      Oracle Custom SQL

       

      When I attempt to create an extract I keep getting an error stating "Unable to materialize temporary table" and subsequently "Unable to create extract".  I'm at a loss.  Does anyone have any ideas on how to resolve?

       

      For purposes of question.  Three data sources:

      1. GoogleSheet1 (Primary)
      2. GoogleSheet2 (Left Outer Join)
      3. OracleSQL (Left Outer Join)

       

      • GoogleSheet1 is the Primary data source with GoogleSheet2 and OracleSQL joining (via left outer join).
      • Joining structure:
        • GoogleSheet1 to GoogleSheet2 Join:
          • Record ID (Number)
          • Effective Date (Date)
        • GoogleSheet1 to OracleSQL Join:
          • Record ID (Number)
            • Default data type for OracleSQL is Number (Decimal)
            • Default data type for GoogleSheet1 is String (Number (Decimal) forced)

      Selection_009.png

      Tableau Stats:

      Version: 10.1.1(10100.16.1103.2343) 64-bit

      Selection_010.png