By Taylor Mcgrath

Bizzabo Events - Snowflake

Integrates with:

<img width="260" height="200" alt="" data-srcset="https://rivery.io/wp-content/uploads/2021/01/snowflake.png 260w, https://rivery.io/wp-content/uploads/2021/01/snowflake-250x192.png 250w" data-src="https://rivery.io/wp-content/uploads/2021/01/snowflake.png" data-sizes="(max-width: 260px) 100vw, 260px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="260" height="200" alt="" data-srcset="https://rivery.io/wp-content/uploads/2021/01/snowflake.png 260w, https://rivery.io/wp-content/uploads/2021/01/snowflake-250x192.png 250w" data-src="https://rivery.io/wp-content/uploads/2021/01/snowflake.png" data-sizes="(max-width: 260px) 100vw, 260px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="260" height="200" alt="" data-srcset="https://rivery.io/wp-content/uploads/2021/01/snowflake.png 260w, https://rivery.io/wp-content/uploads/2021/01/snowflake-250x192.png 250w" data-src="https://rivery.io/wp-content/uploads/2021/01/snowflake.png" data-sizes="(max-width: 260px) 100vw, 260px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="260" height="200" alt="" data-srcset="https://rivery.io/wp-content/uploads/2021/01/snowflake.png 260w, https://rivery.io/wp-content/uploads/2021/01/snowflake-250x192.png 250w" data-src="https://rivery.io/wp-content/uploads/2021/01/snowflake.png" data-sizes="(max-width: 260px) 100vw, 260px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="260" height="200" alt="" data-srcset="https://rivery.io/wp-content/uploads/2021/01/snowflake.png 260w, https://rivery.io/wp-content/uploads/2021/01/snowflake-250x192.png 250w" data-src="https://rivery.io/wp-content/uploads/2021/01/snowflake.png" data-sizes="(max-width: 260px) 100vw, 260px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="260" height="200" alt="" data-srcset="https://rivery.io/wp-content/uploads/2021/01/snowflake.png 260w, https://rivery.io/wp-content/uploads/2021/01/snowflake-250x192.png 250w" data-src="https://rivery.io/wp-content/uploads/2021/01/snowflake.png" data-sizes="(max-width: 260px) 100vw, 260px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="260" height="200" alt="" data-srcset="https://rivery.io/wp-content/uploads/2021/01/snowflake.png 260w, https://rivery.io/wp-content/uploads/2021/01/snowflake-250x192.png 250w" data-src="https://rivery.io/wp-content/uploads/2021/01/snowflake.png" data-sizes="(max-width: 260px) 100vw, 260px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="260" height="200" alt="" data-srcset="https://rivery.io/wp-content/uploads/2021/01/snowflake.png 260w, https://rivery.io/wp-content/uploads/2021/01/snowflake-250x192.png 250w" data-src="https://rivery.io/wp-content/uploads/2021/01/snowflake.png" data-sizes="(max-width: 260px) 100vw, 260px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="260" height="200" alt="" data-srcset="https://rivery.io/wp-content/uploads/2021/01/snowflake.png 260w, https://rivery.io/wp-content/uploads/2021/01/snowflake-250x192.png 250w" data-src="https://rivery.io/wp-content/uploads/2021/01/snowflake.png" data-sizes="(max-width: 260px) 100vw, 260px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="260" height="200" alt="" data-srcset="https://rivery.io/wp-content/uploads/2021/01/snowflake.png 260w, https://rivery.io/wp-content/uploads/2021/01/snowflake-250x192.png 250w" data-src="https://rivery.io/wp-content/uploads/2021/01/snowflake.png" data-sizes="(max-width: 260px) 100vw, 260px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="260" height="200" alt="" data-srcset="https://rivery.io/wp-content/uploads/2021/01/snowflake.png 260w, https://rivery.io/wp-content/uploads/2021/01/snowflake-250x192.png 250w" data-src="https://rivery.io/wp-content/uploads/2021/01/snowflake.png" data-sizes="(max-width: 260px) 100vw, 260px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="260" height="200" alt="" data-srcset="https://rivery.io/wp-content/uploads/2021/01/snowflake.png 260w, https://rivery.io/wp-content/uploads/2021/01/snowflake-250x192.png 250w" data-src="https://rivery.io/wp-content/uploads/2021/01/snowflake.png" data-sizes="(max-width: 260px) 100vw, 260px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="260" height="200" alt="" data-srcset="https://rivery.io/wp-content/uploads/2021/01/snowflake.png 260w, https://rivery.io/wp-content/uploads/2021/01/snowflake-250x192.png 250w" data-src="https://rivery.io/wp-content/uploads/2021/01/snowflake.png" data-sizes="(max-width: 260px) 100vw, 260px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="260" height="200" alt="" data-srcset="https://rivery.io/wp-content/uploads/2021/01/snowflake.png 260w, https://rivery.io/wp-content/uploads/2021/01/snowflake-250x192.png 250w" data-src="https://rivery.io/wp-content/uploads/2021/01/snowflake.png" data-sizes="(max-width: 260px) 100vw, 260px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="260" height="200" alt="" data-srcset="https://rivery.io/wp-content/uploads/2021/01/snowflake.png 260w, https://rivery.io/wp-content/uploads/2021/01/snowflake-250x192.png 250w" data-src="https://rivery.io/wp-content/uploads/2021/01/snowflake.png" data-sizes="(max-width: 260px) 100vw, 260px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="260" height="200" alt="" data-srcset="https://rivery.io/wp-content/uploads/2021/01/snowflake.png 260w, https://rivery.io/wp-content/uploads/2021/01/snowflake-250x192.png 250w" data-src="https://rivery.io/wp-content/uploads/2021/01/snowflake.png" data-sizes="(max-width: 260px) 100vw, 260px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="260" height="200" alt="" data-srcset="https://rivery.io/wp-content/uploads/2021/01/snowflake.png 260w, https://rivery.io/wp-content/uploads/2021/01/snowflake-250x192.png 250w" data-src="https://rivery.io/wp-content/uploads/2021/01/snowflake.png" data-sizes="(max-width: 260px) 100vw, 260px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="260" height="200" alt="" data-srcset="https://rivery.io/wp-content/uploads/2021/01/snowflake.png 260w, https://rivery.io/wp-content/uploads/2021/01/snowflake-250x192.png 250w" data-src="https://rivery.io/wp-content/uploads/2021/01/snowflake.png" data-sizes="(max-width: 260px) 100vw, 260px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="260" height="200" alt="" data-srcset="https://rivery.io/wp-content/uploads/2021/01/snowflake.png 260w, https://rivery.io/wp-content/uploads/2021/01/snowflake-250x192.png 250w" data-src="https://rivery.io/wp-content/uploads/2021/01/snowflake.png" data-sizes="(max-width: 260px) 100vw, 260px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="260" height="200" alt="" data-srcset="https://rivery.io/wp-content/uploads/2021/01/snowflake.png 260w, https://rivery.io/wp-content/uploads/2021/01/snowflake-250x192.png 250w" data-src="https://rivery.io/wp-content/uploads/2021/01/snowflake.png" data-sizes="(max-width: 260px) 100vw, 260px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="260" height="200" alt="" data-srcset="https://rivery.io/wp-content/uploads/2021/01/snowflake.png 260w, https://rivery.io/wp-content/uploads/2021/01/snowflake-250x192.png 250w" data-src="https://rivery.io/wp-content/uploads/2021/01/snowflake.png" data-sizes="(max-width: 260px) 100vw, 260px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="260" height="200" src="https://rivery.io/wp-content/uploads/2021/01/snowflake.png" class="attachment-full size-full" alt="" srcset="https://rivery.io/wp-content/uploads/2021/01/snowflake.png 260w, https://rivery.io/wp-content/uploads/2021/01/snowflake-250x192.png 250w" sizes="(max-width: 260px) 100vw, 260px" />

The Bizzabo Events Kit loads event data into snowflake using the Bizzabo Events rest api to help analyze engagement and registration data.

API reference: https://bizzabo.api-docs.io/v2.0/events/get-event

This kit includes

Action River to extract data from the GET Events Bizzabo endpoint.
Data Source to Target river to load the results of this action into Snowflake.

Minimum RPU Consumption: 1

You can find the full contents, data model documentation, and source fields used here.

Configuring this kit for use

Variables

In this template, there are three variables that are used to make for dynamic use of target configuration. {db_bizzabo} is used in all Target configurations and queries as the target database name. {schema_bizzabo} is used in all Target configurations and queries as the target schema name. {api_token_bizzabo} represents the API token that you need to pass into the action call in order to authorize it. Go to the Variables menu on the left side navigation bar and create variables for db_bizzabo, api_token_bizzabo and schema_bizzabo. Then fill in the values as the Snowflake database and schema where you would like the data to land and the api_token as obtained from bizzabo.