After debating the idea in my head and reading further documentation on warehouses (effectively database), wouldn’t it be more manageable to have one data source being reflected as one warehouse?
Let’s say that we have 3 “connections”: Segment, Stitch, Luigi.
We would then have
segment.source_name.table_name
stitch.source_name.table_name
luigi.source_name.table_name
Then we could scale up or down these warehouses individually! Let’s imagine that we have an influx of Frontend events and we need to scale up the Segment database for better processing, then it would only affect that source of data instead of potentially scaling up for every data sources in the example of the “raw” database containing everything.
Have you hit issues or slowdown by having all the “connector” syncs into the same database? @dapearce