Can't create tables in unity catalog
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-02-2025 07:09 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-05-2025 06:49 AM
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
