@karthik p​ I tested the following. uploaded the sql files to /User and it worked fine. so a notebook in the /Shared folder can access the sql in the /User folder but can not access in the ?Shared folder.

i used cp just to test. but in the original code, i'm using dbutils.fs.ls("file:/ the sql path")