How do you connect a folder path from your desktop to DB notebook?

[ricard98]

I have a folder with multiples excel files that contains information from different cost centers, these files get update every week , im trying to upload all these files to the DB notebook , is there a way to connect the path directly to the DBFS to avoid uploading file by file.

[User16873043099]

Hello, Thanks for your question.

You can mount a cloud object storage to dbfs and use them in a notebook. Please refer here.

It is not possible to mount a local folder from desktop to dbfs. But you should be able to use the Databricks CLI to copy the entire folder to dbfs.

[Hubert-Dudek]

Exactly. Additionally, if you use Azur, you can install it for your windows Azure Storage Explorer, so you can drag and drop files.

If you are using One Drive / Sharepoint for your excels, you can achieve automation in copy files to Azure Data Lake Storage using tools like "Power Automate," "Logic Apps," and "Azure Data Factory".

[jose_gonzalez]

Hi @ricard castañeda​,

Just a friendly follow-up. Did any of the responses help you to resolve your question? if it did, please mark it as best. Otherwise, please let us know if you still need help.