Temporary tables exist at the session level in SQL Data Warehouse. They are defined as local temporary tables and unlike SQL Server tables they can be accessed from anywhere inside the session.