https://www.growthbook.io/ logo
m

microscopic-diamond-71089

03/01/2023, 3:59 AM
If we use custom data source, for example mysql, what is the best pratice database schema do we need to prepare? What table and field need to define? Is there any document mention about that?
f

fresh-football-47124

03/01/2023, 4:00 AM
Most companies have some sort of event tracking that they can use
at a basic level, you need a table that logs experiment name, user id, variation id, and the date they were included in the experiment
but you want to have other metrics you can test against
so you’ll want to have other data in the warehouse
m

microscopic-diamond-71089

03/01/2023, 4:08 AM
Is there any best pratice or hint about defining database structure model to be compatible with Growthbook?
f

fresh-football-47124

03/01/2023, 4:08 AM
what kind of product do you have?
m

microscopic-diamond-71089

03/01/2023, 4:10 AM
We hope to use Growthbook to define testing of UI in our mobile application and some marketing policy in retail banking.
f

fresh-football-47124

03/01/2023, 4:11 AM
do you have event tracking currently?
m

microscopic-diamond-71089

03/01/2023, 4:13 AM
Yes, we have but we are on the way to recontruct our datalake and datawarehouse.
f

fresh-football-47124

03/01/2023, 4:13 AM
I see
since you’re in banking
I assume you can’t use firebase?
m

microscopic-diamond-71089

03/01/2023, 4:19 AM
yes, data is saved on onpremise only.
f

fresh-football-47124

03/01/2023, 4:24 AM
interesting… not too many choices, are you thinking of building something in house for event tracking?
m

microscopic-diamond-71089

03/01/2023, 4:26 AM
not all in house but most of them are in house. For some UI response of mobile application which are already in firebase, we can use cloud base solution.
f

fresh-football-47124

03/01/2023, 4:27 AM
so we can work with firebase’s data
m

microscopic-diamond-71089

03/01/2023, 4:28 AM
how about data saved on onpremise?
f

fresh-football-47124

03/01/2023, 4:28 AM
you could also look at Rudderstack
You can run GrowthBook on-prem or in our cloud, it’s the same product
Jeremy would be a good person to chat about possible solutions for your use case. I’d be happy to set up a quick meeting with him if you like
m

microscopic-diamond-71089

03/01/2023, 6:31 AM
thanks so much for your advice. I've just review Rudderstack and it works like what we do using Kafka. I can imaging the general picture when using growthbook now.
👍 1
5 Views