Kafka stream stops working

Hi Experts,

I am a beginner on confluent kafka cloud.
I created a stream for testing table to table(azure sqldb) movement of data in upsert mode.

The job works for few hrs then it stops inserting and updating.

Is it because I am on a free cluster or something I am missing.

I am using sqlserver source and sink.

The updates reach the target when the job is created fresh but after few hrs get stuck in topic .

Any help is appreciated.


On further analysis I found that the kafka jdbc connection to the target db gets dropped after some time.
Any ideas why this is happening.