Set up AIS data warehouses

Last updated on October 24, 2024

AGS Shared Cloud

Data warehouse integrations are not available on the AccelByte Gaming Services (AGS) Shared Cloud tier.

Overview

This article contains information on how to connect the AccelByte Intelligence Service (AIS) with data warehouses.

Set up Amazon S3 data warehouse

AGS supports outputting directly to Amazon S3 buckets. The data is structured into text files containing JSON representations of each event, which can then be processed by your own systems.

AccelByte can integrate the Game Telemetry pipeline with S3 for you. Provide us the S3 bucket name that you want events to be written to. AccelByte will provide an IAM representing your connector. Once you add this IAM to the security for your S3 bucket, the configuration will be complete.

Set up Redshift data warehouse

AccelByte can create a connector for you in Kafka Connect, to pull event data from Kafka and write the data to Redshift. Nested data will be flattened in the Game Telemetry pipeline, before getting pushed into Kafka. Each payload attached to the events will be converted into a Redshift column.

AccelByte can integrate the Game Telemetry pipeline with Redshift for you. To do so, you'll need to send us the following information:

• Redshift credentials
• Redshift database name

After we apply that information into Kafka Connect, the connector will be created and the pipeline will automatically send Game Telemetry Data to Redshift.

Set up Snowflake data warehouse

Before connecting Snowflake to AGS, follow these steps first in your Snowflake account:

1. Create an ACCOUNTADMIN role. See Snowflake's documentation on creating roles.

2. Create a new database for the data warehouse integration. See Snowflake's documentation on creating databases.

3. Assign the following access requirements to the role you created:

   • Create an integration privilege.

   • Grant ownership to the desired database and schema.

4. Assign the role you created to the user who will be responsible for managing the database. See Snowflake's documentation on granting roles to users.

After completing these steps in your Snowflake account, you can then connect Snowflake to AGS. Refer to the Connect Snowflake to AGS section in the Set up data warehouses article.

What's next?

After integrating your data warehouse with AIS, you can:

• Learn how to use data warehouse tables in AIS. See Data Warehouse Tables.
• Set up your preferred data connector. See Set up data connectors.