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

careful-oyster-228

02/12/2023, 1:40 AM
Hi all, I see that one of the data sources options is postgresql. I’m just starting out and will be fine creating a new db and putting data into it. Is there a guide as to what the schema should be and how I should connect GrowthBook to that new db?
f

fresh-football-47124

02/12/2023, 1:41 AM
Hi Munjal, it depends a bit on what your ab testing on
at a minimum you need a table that tracks exposures, which has a user id (or whatever your randomization unit is), the experiment name, variation id, and a timestamp of when the exposure occurred
c

careful-oyster-228

02/12/2023, 1:43 AM
I’m just looking at the above. I’m happy to put whatever is needed to get as much data is needed
To get a robust set of analysis
I just need to know what
And then I’d need to know how to map that data to GrowthBook
f

fresh-football-47124

02/12/2023, 1:47 AM
so in GrowthBook, you can write SQL to query the exposures, and any metrics you’re trying to use in the A/B tests. If you’re not using an event tracker, you can write SQL to match whatever data you have
c

careful-oyster-228

02/12/2023, 1:48 AM
Ok
7 Views