Upgrade: Temporary tables

Due to the distributed nature of Maia, temporary tables can't be supported. Temporary tables only exist within the database session that created them, but Maia will create multiple sessions for parallelism, making it impossible to reference temporary tables.

---

Upgrade path

If your job uses temporary tables, refactor the migrated pipeline to use one of the following, depending on your environment:

• Transient tables in Snowflake.
• Permanent tables in Databricks.
• Permanent tables in Amazon Redshift.