BigQuery

BigQuery is a powerful data warehouse service on Google Cloud Platform (GCP), offering robust capabilities for large-scale data analytics. Integrating BigQuery with AIRIS enables you to unify your diverse data sources, creating a comprehensive foundation for customer insights.

Once you connect BigQuery to your AIRIS account, you can export data from AIRIS to BigQuery for advanced analysis and reporting.

Connect BigQuery to AIRIS

To enable the integration, complete these setup steps:

1. Create a BigQuery dataset and service account.
2. Add the connection in the Appier console.

1. Create a BigQuery dataset and service account

Before you can connect AIRIS to BigQuery, you need a dataset and service account with the appropriate permissions. Complete the following steps:

1. Create a BigQuery dataset.
2. Create a Google Cloud service account. Grant it the BigQuery User role at the project level.
3. Create a new key for your service account and download a private key in JSON format.
4. Return to the BigQuery console and grant the service account dataset access permission. Assign the following roles to the service account for the specific dataset:
   • BigQuery Data Editor
   • BigQuery Data Viewer

👍

Tip

For optimal performance and data availability with AIRIS, we recommend that you select a Multi-region location when you create your BigQuery dataset.

2. Add the connection in the Appier console

In the Appier enterprise console, go to Common settings > Partner integrations, click BigQuery, then click + Connect BigQuery.

Enter a descriptive name for this connection and the BigQuery's account details, then click Connect:

• Dataset ID: The ID copied from BigQuery's console.
• Service account key: The downloaded account key.

📘

Note

To ingest your BigQuery data into AIRIS, see BigQuery (AIRIS).

Export data to BigQuery

You can export activity reports from AIRIS to BigQuery in two ways:

• Click Export manually from an activity report for one-time exports
• Create a scheduled batch to automatically export activity reports on a recurring basis

Export notes

• Large exports are processed in batches of 5 million records. You can see batches appear in BigQuery as they are processed.
• All fields are exported as strings. To convert data to other BigQuery data types, see BigQuery's documentation.
• The resulting BigQuery tables are named using these formats:

Troubleshooting

Permission denied (Error 403)

This is the most common export failure and occurs when your service account lacks the necessary BigQuery permissions. To resolve this issue, ensure your service account has:

• BigQuery User role at the project level
• BigQuery Data Viewer and BigQuery Data Editor permissions on the specific dataset.