Hi @Suheb ,

The easiest way to bring your local dataset (CSV, Excel, JSON, etc.) into Databricks is by creating a Volume, uploading your files there, and then creating a table on top of that data.

Here’s how you can do it step by step:

1. Create a Volume (recommended approach)

• In the Catalog Explorer, go to your schema (e.g., catalog.my_schema).

• Click Create → Volume and give it a name (e.g., raw_data).

• A Volume provides a secure, governed storage location for your files, managed by Unity Catalog.

2. Upload your local file

• Open the Volume you just created.

• Click Upload → Choose file, then select your CSV, Excel, or JSON file from your computer.

• Databricks will store it in that Volume path ( Click and copy path).

3. Create a Table referencing the file

• Once uploaded, you can create a table directly in SQL:

4. Keep adding new files (optional)

• If you upload more files into the same Volume folder, the table will automatically read all of them, perfect for incremental uploads.

5.Alternative option

• You can also use the “Upload Data” button from the Workspace UI (Data tab) if you just want a quick, one-off import. But Volumes are best if you plan to keep the data managed and reusable.