Can't create tables in unity catalog

Kit — Mon, 03 Feb 2025 03:09:39 GMT

I am facing the problem that is very similar to https://community.databricks.com/t5/data-engineering/can-t-create-table-in-unity-catalog/td-p/93414. However, there is no answer there so I create a new post.

I created my workspace with terraform, with custom VPC. I can create catalogs but not tables. When I tried to create table with `create table catalog.schema.test`, I got this error `[RequestId=428232c9-2b6a-490f-bd1b-7e63b1687834 ErrorClass=TABLE_DOES_NOT_EXIST.RESOURCE_DOES_NOT_EXIST] Table '08c313c4-0d8c-40da-beff-4c4088eab919' does not exist.`

I can see there is a new empty folder created in my metastore with name `08c313c4-0d8c-40da-beff-4c4088eab919`.

Can anyone help me to resolve this erro?

Re: Can't create tables in unity catalog

Ayushi_Suthar — Wed, 05 Feb 2025 14:49:57 GMT

Hi @Kit , Greetings!

Can you try to create a table with the following SQL command: CREATE OR REPLACE TABLE table_name ().

Also can you please which cluster you are using here? Make sure you are using the UC-supported cluster.

Leave a like if this helps, followups are appreciated.
Kudos,

Ayushi

topic Re: Can't create tables in unity catalog in Data Engineering

Can't create tables in unity catalog

Re: Can't create tables in unity catalog