Hello. I'm using the Facebook Marketing source and connecting it to a Redshift destination, and I need to do this across multiple ad accounts. I understand at this time each ad account needs to be a separate source and therefore a separate connection. I do however, need all the data collected into a single set of table on the Redshift side. If I make a change to any of the connections, Airbyte asks to "reset the streams" which results in all the data being deleted, including data that was sourced from other ad accounts. Is it safe to never reset the streams? Are there any better patterns around handling this?

You could use DBT as a transformation into a single table?

I'm hoping to avoid any additional complexity like DBT, at that point our existing home grown solution, or even commercial solutions like Hevo and IntegrateIO become more appealing

Hello Sharat Visweswara, it's been a while without an update from us. Are you still having problems or did you find a solution?