With this guide, we intend to show you how to set up Snowflake to import and use the daily reporting data exports provided by Beat. Before you get started with this guide, we suggest you familiarize yourself with the reporting section of our documentation.

Snowflake is a data warehouse solution that is adept at importing and processing information from a large number of data sources. It builds on a foundation that will be familiar to database engineers; namely working with relational tables and SQL.

In this guide we will create a setup that imports the data we expose in Snowflake, and provide guidance on how the data can be processed further to make royalty calculations that fit your business rules.

In summary, we will:

Provide a method of importing the daily snapshots, such as:
- Releases
- Actors (authors, translators, narrators)
- Users
- Subscriptions
- Products
- User release groups and their contents (includes bookshelves)
Provide a method of importing consumption events, and provide examples that show how to:
- efficiently process the large number of events coming in
- create reports of consumption on a user and release level

Beat Technology takes responsibility for the data exports delivered to Backblaze. You are responsible for ensuring the processing done in Snowflake (or elsewhere) matches your business requirements. The information in this guide is strictly informative, and Beat Technology provides it as a courtesy. You need to verify that this data is complete and exhaustive, and that it meets your business requirements.

</aside>

Since this guide is extensive, we will divide it into sections, where each section builds on the previous. You should therefore go through it in order.

Guidelines for using Beat’s hosted Snowflake

Preparation

Working with encrypted data

Importing data

Importing snapshot data

Importing periodic data