Hello there! Is there a webhook for experiment cal...
# ask-questionsd
delightful-city-54850
03/13/2023, 2:53 PMHello there! Is there a webhook for experiment callbacks so we can record that data directly in Snowflake or do we have to go through an event tracking service like Rudderstack?
f
fresh-football-47124
03/13/2023, 4:01 PM
Hi Crystal, when you use GrowthBook, we have a ‘trackingCallback’ which fires when a user is put into an experiment
fresh-football-47124
03/13/2023, 4:01 PM
from there you can push data to snowflake (or any data source) anyway you like
fresh-football-47124
03/13/2023, 4:02 PM
we do suggest using something like Rudderstack or Jitsu or Segment for this, so the pipelining is taken care of
d
delightful-city-54850
03/13/2023, 8:00 PMHey @fresh-football-47124 - we are setting up our design right now and I saw the tracking callback mechanism but noticed it was dependent on an analytics.track call within the callback.
We have Rudderstack too but with scale, we wanted to think about cost efficiency since Segment/Rudderstack costs $$$ for incremental rows of data so would have liked that data persisted and sent directly to Snowflake if we could bypass that step somehow
f
fresh-football-47124
03/13/2023, 8:01 PM
what you use inside that tracking callback is up to you
fresh-football-47124
03/13/2023, 8:01 PM
we just need some way to get that info back out of your warehouse
👀 1
fresh-football-47124
03/13/2023, 8:02 PM
it should just be one additional event - Jitsu tends to be quite cheap for this
d
delightful-city-54850
03/13/2023, 8:02 PMOk perfect, will float this with the team as an option 🙂 thank you!!
delightful-city-54850
03/13/2023, 8:03 PMwhen you say, “get that info back out of your warehouse” — is this for experiment analysis?
f
fresh-football-47124
03/13/2023, 8:03 PM
yes
fresh-football-47124
03/13/2023, 8:03 PM
the trackingCallback is only used for a/b tests experiments
🙌 1
d
delightful-city-54850
03/13/2023, 8:04 PMOk I see…we’re still in setting up the SDK and now dabbling with how to analyze experiments and connect snowflake & ruddstack data. I would probably run into these questions soon enough so thank you for answering them proactively 😄
delightful-city-54850
03/13/2023, 8:06 PMAlso just assuming, with our business data in snowflake, we can still use that in experiment analysis using the same workflow as Rudderstack documentation?
delightful-city-54850
03/13/2023, 8:06 PMAlso a Snowflake guide would be nice in the How to Guides 😁
f
fresh-football-47124
03/13/2023, 8:06 PM
yes, it would be the same or similar
🙌 1
fresh-football-47124
03/13/2023, 8:07 PM
the trouble with a Snowflake guide is that there is no default schema to use - so its hard to tell people how to use it
fresh-football-47124
03/13/2023, 8:07 PM
it would just be how to get the credentials and connect to your warehouse - would you find that useful?
d
delightful-city-54850
03/13/2023, 8:10 PMAh I see — I’m a big fan of one big table schemas (vs star schema) so a lot of our major metrics is in one final table we use for reporting.
I can think about what would be useful as I go through this journey but definitely:
• How to connect with credentials and the right role setting for Growthbook
• How to setup metrics from Snowflake tables and start doing experiments
136 Views