#ask-questions
Title
m
microscopic-diamond-71089
03/01/2023, 3:59 AMIf 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 AMIs 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 AMWe 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 AMYes, 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 AMyes, 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 AMnot 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 AMhow 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 AMthanks 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