Finally I followed steps from this blog, and everything works fine.

https://www.databricks.com/blog/2022/04/25/simplifying-change-data-capture-with-databricks-delta-liv...

I just assumed that I have tables as sources and not flat files.

Happy reading!