Is there a way to get multiple tap streams to load...
# troubleshooting
l
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
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
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