07-28-2025 01:18 PM
Hello!
We have some production data pipelines using delta shares that have previously worked but broken today and I can't find a new solution.
I create a delta share:
07-30-2025 03:39 AM - edited 07-30-2025 03:54 AM
Hello @nick-monda!
You're right, if a table is being shared through Delta Sharing, you'll get that error when attempting to drop it directly. Could you share the error message you’re seeing when running the ALTER SHARE ... REMOVE TABLE command?
Also, try running SHOW ALL IN SHARE ... command and note exactly how the table is listed, whether by alias or original name, and use that exact format in your command.
07-30-2025 04:56 AM
Hello, sorry about that. Here is the error when trying to remove:
ServerOperationError("[RequestId=f9953228-bb3a-4740-89dc-253a11e1d8b4 ErrorClass=TABLE_DOES_NOT_EXIST.RESOURCE_DOES_NOT_EXIST] Table 'local_new_2022.default.new_2022' does not exist.")
07-30-2025 12:25 PM
Wanted to note,
I see that the path is shows on the "not found" table is local_new_2022.default.new_2022, which looks like it is including local_new_2022 as a database?
When I try something the full table path:
ALTER SHARE local_new_2022 REMOVE TABLE amplifydata_local_local.default.a3cfbc5bd7bc947eaa8526d48c77e1d39
I get this:
ServerOperationError: [RequestId=d25f1c81-092b-449e-bb4e-375921e39c28 ErrorClass=RESOURCE_DOES_NOT_EXIST.RESOURCE_DOES_NOT_EXIST] Shared Table 'default.a3cfbc5bd7bc947eaa8526d48c77e1d39' does not exist.
Interestingly, it is not including this first reference, aka there is no database, it is only default and the table name.
08-01-2025 10:16 AM
Hello Nick,
According to the Delta Sharing Examples page, you cannot use the three namespace convention. It should be:
Aren't you mixing Unity Catalog assets and Delta Share assets when dropping? I think that is why you're getting "RESOURCE_DOES_NOT_EXIST" on your last example.
08-01-2025 10:29 AM
I was showing examples of all the queries I have tried.
I add the table:
ALTER SHARE local_new_2022 ADD TABLE `amplifydata_local_local`.`default`.`a3cfbc5bd7bc947eaa8526d48c77e1d39` AS `default`.`new_2022`;
then I try to remove the table with the alias:
ALTER SHARE local_new_2022 REMOVE TABLE default.new_2022;
and it does not work. However, this query has worked for months up to this week.
08-01-2025 10:58 AM - edited 08-01-2025 11:02 AM
Where are you running these queries?
Warehouses or clusters? If clusters, what DBR version?
Did you recently changed the compute type by any chance?
08-01-2025 11:02 AM
We are using the databricks_sql python sdk:
```python
Passionate about hosting events and connecting people? Help us grow a vibrant local community—sign up today to get started!
Sign Up Now