Migrating data from a CSV source: Where should the source go?
Please add the file as :

source:
  plugin: csv
  path: 'public://csv/test.csv'


And under sites/default make a folder named as csv and place the file inside that. It will work.