Hey all 👋 looking for some guidance on a segment + snowflake best practices. Segment recommends setting up QA and Production apps
as different sources, and this results in one schema per application+environment combination when the data ends up in Snowflake. Growthbook appears to require the schema info to connect to a data source, so we ended up with 4 total data sources (Prod/QA and Frontend/Backend split). We've found that this doesn't play very well with features, for example - creating a/b experiment overrides end up tied to a single Datasource for prod and qa.
Is there a better way to think about organizing our data? We've also considered creating views to consolidate prod and qa schemas into single ones, though I don't believe this solves the issue about experiment override creation. Perhaps views by application are better?