Hi @Srikanth ,
As far as I know, currently only the office files are supported to be opened in desktop app directly from SharePoint. We can not open Auto CAD files(.dwg) in a in a desktop app directly from SharePoint.
Here are two options for you:
1.open Auto CAD files in web app, then open it in Desktop
2.download the file to local then open it.
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.