First create a table from the file and then read the table via workspace. This has worked for me.
Under Catalog, click the "+" button and then "Add Data" > "Create or modify data" > give the name of the table and upload the file.
Once done, use below command to access the table (orders_230714_200740)::
order_df = spark.read \
.format("csv") \
.option("header","true") \
.table("workspace.default.orders_230714_200740")
DBFS is disabled in your Databricks workspace, that usually means you’re in a Unity Catalog–enabled environment. In UC-enabled workspaces, direct access to dbfs:/ is restricted.
Instead you must use external locations or volumes registered in Unity Catalog.
