topic Re: Save as Delta file in catalog in Data Engineering

Save as Delta file in catalog

Hritik_Moon — Fri, 10 Oct 2025 06:46:33 GMT

Hello, I have created data frame on csv file when I try to write it as:

df_op_clean.write.format("delta").save("/Volumes/optimisation/trial")

I get this error :

Cannot access the UC Volume path from this location. Path was /Volumes/optimisation/trial/_delta_log

I am able to save as table on the same location.

Re: Save as Delta file in catalog

-werners- — Fri, 10 Oct 2025 09:42:12 GMT

When writing delta using UC (Volumes are part of UC) it expects a table.
So in your case you mix the two, you want to use Volumes to write files but UC expect a table when using delta.
Either save as a table or as a file (but not in delta format or outside of UC).
Exactly what you have tried already.

Re: Save as Delta file in catalog

-werners- — Fri, 10 Oct 2025 09:49:12 GMT

Also to add on this:
avoid overlap between tables and Volumes.
Create a separate folder for tables and files.
Unity catalog does this too if you use managed tables/volumes.