Is there a way to get multiple tap streams to load into the same table in postgres? It seems if I share the "name" across multiple streams only the last one gets added to my destination
a
aaronsteers
12/28/2022, 1:54 AM
Hi, Luke. Generally we recommend a single target table per stream. This ensures straightforward management of restatements, retries, and state tracking in general.
Can you provide more info on your use case?
l
luke_pammant
12/28/2022, 7:12 AM
Ah okay, thanks AJ. I'm using Google Analytics and need to generate 10 reports per customer and we have 30+ customers. So I was trying to get all together into one table so I don't have to write a huge union view. From what I've gathered I'm going to have to do as you said and have 1 table per stream, I can use DBT to programmatically make a view I suppose