File type source only accepts 1 file I guess, if we have 100 CSVs, it will require 100 sources to be created. Is that right understanding?

Hey Chetan it is true. If you have source as S3 you can use S3 connector

ok Let me try with S3 connector