Heya guys, we're looking to roll out Growthbook op...
# ask-questionse
early-battery-30877
02/16/2022, 2:50 AMHeya guys, we're looking to roll out Growthbook open source ontop of a snowflake instance. Is there a way to use public private key authentication with growthbook or does it have to be username + password?
f
fresh-football-47124
02/16/2022, 2:55 AM
Hi Moss. I don't think you can yet. Is this a blocker for you?
e
early-battery-30877
02/16/2022, 2:57 AMHmm, it's a bit of a pain as we tend to use pub priv for all system to snowflake connections. I'm having a squiz to see if it's supported in snowflake-promise the library it looks like you guys are wrapping.
early-battery-30877
02/16/2022, 3:00 AMLooks like it was added last year to that library. https://github.com/natesilva/snowflake-promise/commit/c16ddd5b6280d67d7f25b359ca3dca938530e449
early-battery-30877
02/16/2022, 3:08 AMCheers for the quick response @fresh-football-47124!
We'll see how we go, we might play with a branch and put in a PR if we get it to work. We're planing on seeing if we can deploy growthbook.io in a hackthon Thursday / Friday this week so you might here from us a bit in this channel over the next couple of days 😄
f
fresh-football-47124
02/16/2022, 3:10 AM
okay
fresh-football-47124
02/16/2022, 3:23 AM
Love a good hackathon - please let us know how we can help
e
early-battery-30877
02/16/2022, 3:25 AMCheers man, will do! 🙂
early-battery-30877
02/16/2022, 3:28 AMAre there any things worth considering that aren't in the readme that we should pause and give some deeper consideration to if we're setting it up quickly?
The main one I can see is making sure we find a suitable balance between how much of the metric definition happens in the warehouse +dbt vs in the metric statements. Leaning towards most of the metric processing happening in wh to allow for relatively clean queries in the metrics layer.
f
fresh-football-47124
02/16/2022, 3:29 AM
ya, it's a bit of a trade off. I would tend to agree with your approach. The experiment queries do several joins which can get ugly if the metrics themselves have lots of joins.
👍 1
g
gifted-carpenter-70615
02/16/2022, 9:09 AMFor what its worth @early-battery-30877, we’re doing the latter: so we create separate tables per metric in the warehouse specifically for growthbook (but also because we have tests on them there).
Still trying to figure out if this is a good approach though..
@fresh-football-47124 not sure if this would be an option but is there any particular reason the group assignment and the metrics are separate sets that are joined? I can see both pros and cons here (the con being, in my case they are both a few billion rows big).
f
fresh-football-47124
02/16/2022, 9:23 AM
hi Robin - we might be able to make it work better for your case, would you be up for a meeting so we can understand your use case?
27 Views