Thanks for responding very quick.
It is synapse sql serverless pool.
Regarding the branches, I am developing in feature branch and then commit the changes to it. Then I create the pull request in master branch to merge the changes. Then I come back to my master branch and publish the changes from there.
ideally when I publish those changes , my live mode should be sync with publish/master , but live mode has different more data than master branch.
I have a synapse pipeline which triggers every night, which pulls new records in my lake database. Now I can see the trigger and successful pipeline run at night, but somehow the changes are not reflected in master branch, but i can see them in live mode. I repeated the process so many times.