not able to create temporary tables in unity catalog

[SandeepG]

We are using a unity catalog environment and when trying to create a temporary table the statement errored out.

[Kaniz]

Hi @SandeepG, This article introduces the concept of managed and external tables in Unity Catalog and describes how to create tables in Unity Catalog.

[Sampath_Kumar]

Hi @SandeepG 

Could you please share the need of a temporary table?

Here are the possible ways

• Tables:
  • External Tables: Tables can be created on top of files which are externally located.
  • Managed Tables: The usual tables which will be stored and managed automatically as per the schema and catalog configurations.
  • Reference: Databricks Tables 
• Views:
  • View is a virtual object storing the result of a custom query.
    • Reference: Classic View
  • Temporary view which is limited to the created spark session(within notebook) and global temporary view which is limited to the cluster(within workspace). Both of these are temporarily stored.
    • Reference: Temp Views 
  • Materialized view: It is like a view but it is physically stored. It can be refreshed whenever needed.
    • Reference: Materialized View
• The respective object can be chosen based on the requirement.