Creating pipeline with multiple source files and multiple target tables


Is it possible to create a pipeline with multiple sources files under one folder and multiple target tables?
If yes, please let me know how should I do it.

Also is it possible to write a “CREATE PIPELINE” inside a SP and passing table name and file name as parameters to that SP?

my test case is:
I want to insert data from multiple CSV files into multiple target tables

Thank you in advance :slight_smile: