This message was deleted.
# ask-questions
w
This message was deleted.
b
Hey, Leon! I've got my opinion, but going to check with others on the team just to be sure. 1 sec.
And, Leon - just to confirm, would you like to use the
master
revenue table when analyzing experiments, along with your other data/metrics that live in the same database as the
experiment_viewed
?
c
Right I think so
I think I need the segment/snowflake database for all the experiment viewed and things like product analytics for conversion and ratio metrics. But the revenue table is somewhat separate
b
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.
c
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?
b
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.
Which would allow you to have a single Data Source in GrowthBook.
c
ok i will try
i guess first will try running a simple analysis that live all on the segment database before attempting a more complicated one
👍 1
143 Views