โ05-02-2024 02:24 AM
I am having an issue where when I do a shallow clone using :
โ05-02-2024 07:19 AM
Hi Steven
This is really a strange issue. First let's exclude some possible causes for this. We need to check the following:
- The permission to table A and Catalog B. take a look at the following link to check what permission is needed: https://docs.databricks.com/en/delta/clone-unity-catalog.html
- the cluster you are using to clone is a unity catalog enabled cluster.
- Just to make sure is the "Destination" Table not found or the "Source"
Hopefully by checking those we can figure out why this is happening.
โ05-02-2024 10:44 PM
Hi Omar ๐
I checked those things out and everything seems to be in order. I also spun up a new warehouse and could reproduce the issue.
I was able to resolve the issue by downgrading our warehouse from the โPreviewโ Channel to โCurrentโ Channel, which may mean there has been a bug introduced into the โPreviewโ Channel.
The release notes for Databricks SQL release notes say that both channels use 2024.15, but maybe thereโs been a minor version release in โPreviewโ channel thatโs triggered the issue?
โ05-03-2024 01:57 AM
Hi Steven
Thanks for checking out all the recommended options. I tried to reproduce the error and was not successful. Using both channel preview and current I was able to create a shallow clone of a table. However the channel version for me is 2024.25.
So it might be a hiccup in the 2024.15 preview, but it is resolved in the 2024.25 which soon should be in your region.
Thanks for flagging this up.
โ05-23-2024 12:42 AM
Hi @Omar_hamdan,
I'm now experiencing this error in both preview and current channels (2024.25). Is there a way I can rollback my SQL Warehouse Version until this is resolved?
Excited to expand your horizons with us? Click here to Register and begin your journey to success!
Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!