@Nermin Yehia​ :

It's possible that the SQL files are not being copied over to the Shared workspace during the deployment process. Double-check that the CICD pipeline is configured to include the SQL files in the deployment.

Another possible issue could be with the permissions on the SQL files. Check that the user who is trying to access the SQL files has the necessary permissions to read them. You can try changing the permissions using the chmod command in a notebook cell:

%sh
chmod 644 /dbfs/path/to/sql/file.sql

This will set the permissions on the SQL file to read-only for the owner, and read-only for everyone else. You can also try setting the permissions to read-write for the owner:

%sh
chmod 600 /dbfs/path/to/sql/file.sql

If none of these solutions work, it's possible that there is a more complex issue with the Shared workspace or the deployment process.