Hello Prabhu,
Thank you for posting your question in the Microsoft Q&A forum.
Implementing Azure DevOps Pipelines to automate the deployment of Azure Synapse Analytics data from the Development environment to Production involves several steps. Below is a detailed technical implementation approach to address this business requirement.
https://learn.microsoft.com/en-us/azure/synapse-analytics/cicd/continuous-integration-delivery
https://learn.microsoft.com/en-us/azure/synapse-analytics/
If the above answer helped, please do not forget to "Accept Answer" as this may help other community members to refer the info if facing a similar issue. Your contribution to the Microsoft Q&A community is highly appreciated.