topic Re: unity catalog Request failed with status code 404 in Data Governance

unity catalog Request failed with status code 404

lizou — Wed, 25 Jan 2023 14:02:02 GMT

maybe this is a bug in the unity catalog as the error happens multiple times when a table becomes inaccessible

error: Request failed with status code 404

try to drop the table error: NoSuchTableException: [TABLE_OR_VIEW_NOT_FOUND]

try to replace the table error: TableAlreadyExistsException: [TABLE_OR_VIEW_ALREADY_EXISTS]

the table info still exists in system.information_schema.columns

basically stuck at this state

Re: unity catalog Request failed with status code 404

Anonymous — Sat, 28 Jan 2023 14:32:30 GMT

@lizou What do you mean by "table becomes inaccessible"? Were the underlying table data files deleted by any chance?

Re: unity catalog Request failed with status code 404

lizou — Sun, 29 Jan 2023 13:22:46 GMT

no file deleting. just this error appears, and no way to drop or recreate the table. I also don't know what's GUID of the table is. What else we can do to drop a table without using the drop table statement?

Re: unity catalog Request failed with status code 404

lizou — Sat, 11 Mar 2023 16:01:30 GMT

the error disappeared now after a few months.

It could be

happens when there is a lot of schema change on db during the initial project stage.
there may be some temp security issues
may be databricks fixed in the back end
appears less issue when schema rarely changes after the project get stable and schema is set