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.
Related content
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for