hi folks! trying to get setup with Growthbook. First using it at the reporting layer since we have all of our data in snowflake via Segment, and we also have a ‘master’ revenue table that is hand-crafted by us, which lives in a separate snowflake database. What is the right data source configuration? Should I create one snowflake data source for the Segment data, which houses the ‘Experiment Viewed’ events, etc, and then another data source, also on snowflake for the Revenue database/table? Or is there a way to keep it all to one Data Source within Growthbook?

Hey, Leon! I've got my opinion, but going to check with others on the team just to be sure. 1 sec.

Right I think so

Gotcha. Unfortunately, we don't have any mechanism available to join two databases, so if you were to want to use the data within the

master

revenue table, it would need to be on the same database that the

experiment_viewed

events data is on.

Ok thinking through it - then i maybe need to move or do one of those fancy snowflake zero-copy clone to get the revenue table in the same db as the experiment_viewed one?

Yea, if you can get the revenue table in the same db as the

experiment_viewed

events, then you can build metrics around revenue and use those in the experiment analysis.

ok i will try