How to write files to Databricks Volumes while running code in local VS Code (without cp)

[gowtham-talluru]

How to write files to Databricks Volumes while running code in local VS Code (without cp)

I always struggle to seamlessly use VS Code with databricks. Its so not user friendly. Do you also feel the same?

[SP_6721]

Hi @gowtham-talluru, 

If you're trying to write directly to Volumes from local code, you can use the Databricks SDK for Python.
Try something like this:

from databricks.sdk import WorkspaceClient

w = WorkspaceClient()

with open("local_file.csv", "rb") as f:
   w.files.upload(
      f="/Volumes/catalog/schema/volume/local_file.csv",
      contents=f.read(),
      overwrite=True
   )

Just make sure you're authenticated and the volume exists.