Migration: Temporary tables

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

Migration 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.