Hello Riya C
Welcome to the MS Q&A platform.
Here is a video series by Microsoft Expert on the synapse CI/CD process/best practices/Troubleshooting workspace deployment tasks.
Tech community blogs:
https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/automating-the-publishing-of-workspace-artifacts-in-synapse-cicd/ba-p/3603042
https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/cicd-automation-in-synapse-analytics-taking-advantage-of-custom/ba-p/3513546
https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/cicd-in-synapse-sql-how-to-deliver-your-database-objects-across/ba-p/3267507
I hope this helps. Please let me know in case if you have any further questions.