not able to create temporary tables in unity catalog

SandeepG — Mon, 18 Mar 2024 15:49:51 GMT

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

Re: not able to create temporary tables in unity catalog

Sampath_Kumar — Wed, 20 Mar 2024 02:52:39 GMT

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.