Hi Idan,
You’re on the right track , 1 pipeline to 1 source table (or raw table).
Querying a raw table is not the best approach though because it will grow fast, your queries will slow down and it does not provide you scalability.
I would use stored procedures to grab that data from the raw tables and transform it into different tables. Ideally, fact and dimension tables are better suited for reporting purpose.
Sincerely,
Franck