# Analytic events to Snowflake

**URL:** https://forum.heroiclabs.com/t/analytic-events-to-snowflake/3354
**Category:** Documentation
**Created:** [December 19, 2022, 7:51pm UTC](https://forum.heroiclabs.com/t/analytic-events-to-snowflake/3354 "2022-12-19T19:51:21Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![capnjosh](https://avatars.discourse-cdn.com/v4/letter/c/f475e1/32.png) [@capnjosh](https://forum.heroiclabs.com/u/capnjosh)
#### Post date: [December 19, 2022, 7:51pm UTC](https://forum.heroiclabs.com/t/analytic-events-to-snowflake/3354/1 "2022-12-19T19:51:21Z")

</div>

Are there any examples of using the Nakama events system to push analytic events to Snowflake? I know the events system would allow for such a thing, but I’d like to hear about anybody’s experience doing it.

---

<div class="post-metadata">

### Author: ![AlimJaffer](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.heroiclabs.com/alimjaffer/32/17_2.png) [@AlimJaffer](https://forum.heroiclabs.com/u/AlimJaffer)
#### Post date: [December 19, 2022, 11:18pm UTC](https://forum.heroiclabs.com/t/analytic-events-to-snowflake/3354/2 "2022-12-19T23:18:52Z")

</div>

Hi Josh - you can use Nakama’s [event system](https://heroiclabs.com/docs/nakama/concepts/events/#events) to push events to any 3rd party service including Snowflake, which is the most popular service with customers of ours. Within Satori we also have first party support to push [events to Snowflake](https://heroiclabs.com/docs/satori/concepts/settings/#snowflake) as well as BigQuery and Redshift.

---

<div class="post-metadata">

### Author: ![capnjosh](https://avatars.discourse-cdn.com/v4/letter/c/f475e1/32.png) [@capnjosh](https://forum.heroiclabs.com/u/capnjosh)
#### Post date: [December 20, 2022, 12:21am UTC](https://forum.heroiclabs.com/t/analytic-events-to-snowflake/3354/3 "2022-12-20T00:21:00Z")

</div>

Do you happen to have any examples of that kind of implementation? Do the best implementations you have seen do something like write each event to a file locally and then periodically upload those files to a Snowflake stage?

That, or are you seeing good implementations where people sort of relay events to their own Kafka cluster, and from there use the Snowflake-Kafka systems to get events into tables?

---

<div class="post-metadata">

### Author: ![mofirouz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.heroiclabs.com/mofirouz/32/1523_2.png) [@mofirouz](https://forum.heroiclabs.com/u/mofirouz)
#### Post date: [December 20, 2022, 1:13am UTC](https://forum.heroiclabs.com/t/analytic-events-to-snowflake/3354/4 "2022-12-20T01:13:04Z")

</div>

We’ve seen some customers use the Event system as a buffer to write to Snowflake API directly. However this isn’t recommended by us as the Event system is memory-backed, doesn’t have retry behaviour and it’s at-most once delivery. It’s designed mostly as a not-high input event capture (eg for connecting different game features together like an event bus). It can also be used if you have something local than can accept writes much faster (eg Satori) than a heavy/slow API like Snowflake.

If you do have lots of events data that need to be ingested, either connect a fast queue like Kafka or RabbitMQ to Nakama (sorry no code to share) or use Satori for event ingestion and connect that to Snowflake.
