@Jaya Ojha Welcome to Microsoft Q&A forum and thanks for reaching out here.
Have you got a chance to go through this thread where a similar issue has been discussed? If not kindly review let us know if that helps - CI CD for Synapse spark pool lake database objects.
Thank you
---Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.