Load Klaviyo data into BigQuery

Console

1. Go to the Data transfers page in the Google Cloud console.

   Go to Data transfers

2. Click add Create transfer.

3. In the Source typesection, for Source, choose Klaviyo - Preview.

4. In the Data source detailssection, do the following:

   • For Private API Key, enter your private API key. For more information, see Klaviyo prerequisites .
   • Optional: For Start Date, specify a start date for new records to be included in the data transfer. Only records created on or after this date are included in the data transfer. The default value is 3 months before the transfer run date.
   • For Klaviyo objects to transfer, click Browseto select any objects to be transferred to the BigQuery destination dataset. You can also manually enter any objects to include in the data transfer in this field.

5. In the Destination settingssection, for Dataset, choose the dataset that you created to store your data.

6. In the Transfer config namesection, for Display name, enter a name for the data transfer.

7. In the Schedule optionssection:

   • In the Repeat frequencylist, select an option to specify how often this data transfer runs. To specify a custom repeat frequency, select Custom. If you select On-demand, then this transfer runs when you manually trigger the transfer .
   • If applicable, select either Start nowor Start at set time, and provide a start date and run time.

8. Optional: In the Notification optionssection, do the following:

   • To enable email notifications, click the Email notificationtoggle. When you enable this option, the transfer administrator receives an email notification when a transfer run fails.
   • To enable Pub/Sub transfer run notifications for this transfer, click the Pub/Sub notificationstoggle. You can select your topic name, or you can click Create a topicto create one.

9. Click Save.

bq

Enter the bq mk command and supply the transfer creation flag --transfer_config :

bq  
mk  
--transfer_config  
--project_id = 
 PROJECT_ID 
  
--data_source = 
 DATA_SOURCE 
  
--display_name = 
 NAME 
  
--target_dataset = 
 DATASET 
  
--params = 
 ' PARAMETERS 
' 

Replace the following:

• PROJECT_ID (optional): your Google Cloud project ID. If --project_id isn't supplied to specify a particular project, the default project is used.
• DATA_SOURCE : the data source — klaviyo .
• NAME : the display name for the data transfer configuration. The transfer name can be any value that lets you identify the transfer if you need to modify it later.
• DATASET : the target dataset for the transfer configuration.

• PARAMETERS : the parameters for the created transfer configuration in JSON format. For example: --params='{"param":"param_value"}' . The following are the parameters for a Klaviyo data transfer:

  • assets : the path to the Klaviyo objects to be transferred to BigQuery.
  • connector.authentication.privateApiKey : the private API key for the Klaviyo account.
  • connector.startDate : (Optional) a start date for new records to be included in the data transfer, in the format YYYY-MM-DD . Only records created on or after this date are included in the data transfer. The default value is 3 months before the transfer run date.

The following command creates a Klaviyo data transfer in the default project.

  
bq  
mk  
--transfer_config  
--target_dataset = 
mydataset  
--data_source = 
klaviyo  
--display_name = 
 'My Transfer' 
  
--params = 
  
 ' { 
 "assets": [ "Events" , "Flows"] , 
 "connector.authentication.privateApiKey" : "pk_123456789123", 
 "connector.startDate": "2025-10-20" 
 }'