Integrating your product analytics application with a BigQuery data warehouse that contains product data from Twilio Segment or Rudderstack Customer Data Platforms (CDPs) involves a few key steps. Here's a step-by-step guide to help you through the process.
Before you start, make sure you have the following:
1️⃣ Access to BigQuery: Ensure you have access to a Google Cloud project with BigQuery enabled.
2️⃣ Access to Segment or Rudderstack: You need access to your Twilio Segment or Rudderstack account.
3️⃣ Access to Google Cloud Console: You need administrator privileges and access to the Google Cloud Console.
<aside> 💡 If you don’t know how to access these systems or don’t have the necessary access rights you can invite your colleague as an admin to GrowthCues.
</aside>
For GrowthCues to gain access to the product data, we need to locate the BigQuery tables created by your Twilio Segment or Rudderstack integration. In BigQuery the tables reside in datasets that are created under Google Cloud projects.
GrowthCues needs to know the project name and the dataset name for your BigQuery tables.
Here are the steps to locate the project ID and dataset name from your BigQuery console.
1️⃣ Open your BigQuery explorer on the Google Cloud Console: https://console.cloud.google.com/bigquery
2️⃣ Click on the BigQuery Studio tab on the left navigation panel and click on the dataset containing your product data. See the example screen below.
3️⃣ Under Dataset info hover on the Dataset ID and copy the ID to the clipboard.