Connecting Klaviyo and BigQuery

Create required schemas

1. In the Google Cloud console, select the project where your data is stored.

2. In the project where your data is stored, run the following script to create the necessary schemas.

   CREATE SCHEMA `KLAVIYO_IMPORT_FROM_DWH`;  

   CREATE SCHEMA `KLAVIYO_TMP`;

Create service account

1. In the Google Cloud console, select the project where your data is stored.

2. Visit IAM & Admin > Service accounts.

3. Create a new service account (or select an existing service account).

4. Assign the service account the following roles, scoped to the two schemas you created above.

   1. BigQuery Data Viewer

   2. BigQuery Job User

5. On the Keys tab, create a new private key of JSON type. Your browser will automatically download the key. Keep this file somewhere safe; you'll need this file to create the connection between Klaviyo and BigQuery.