Known issue - Temp table usage in Data Warehouse and SQL analytics endpoint

Users can create Temp tables in the Data Warehouse and in SQL analytics endpoint but data from user tables can't be inserted into Temp tables. Temp tables can't be joined to user tables.

Status: Open

Product Experience: Data Warehouse

Symptoms

Users may notice that data from their user tables can't be inserted into a Temp table. Temp tables can't be joined to user tables.

Solutions and workarounds

Use regular user tables instead of Temp tables.