Add BigQuery to Fulcrum

To add BigQuery to Fulcrum and send warehouse data to Fulcrum, follow these steps:

Step 1: Navigate to the Fulcrum's Integration Page

Step 2: Select "Connect" by BigQuery

  • On the integration page, look for the BigQuery integration. Fulcrum BigQuery Integration

  • Once you find the BigQuery integration, click on the "Connect". This will initiate the integration setup.

Step 3: Configure BigQuery Service Account

  • Open a new tab in your web browser and go to Service Accounts in the Google Cloud console (opens in a new tab).

  • Select a project you want to use for connecting BigQuery.

  • Create a new service account for Fulcrum with the permissions BigQuery User Fulcrum BigQuery Service Account

  • Assign BigQuery User permission to the service account and click Done. Fulcrum BigQuery Service Account Permissions

  • Click into the service account you just created and Add Keys to the service account. Choose json type for the keys and click Create. Fulcrum BigQuery Service Account Keys

  • Download the json file. You will need the file to complete the setup

Step 4: Upload BigQuery Service Account File to Fulcrum

  • Return to the Fulcrum integration page you accessed in Step 1.

  • Upload the JSON key file you obtained in Step 3 into this field. Fulcrum BigQuery Service Account File Upload

  • After confirming the upload, click on the "Connect BigQuery" button to proceed.

Step 5: Configure Fulcrum with BigQuery

  • Select BigQuery Dataset to use for Fulcrum Fulcrum BigQuery Dataset

  • Choose User table to ingest user properties. Select a unique user ID column. Fulcrum BigQuery Configure User

  • Choose Organization table to ingest org properties. Select a unique org ID column. Fulcrum BigQuery Configure Organization

  • Finally, choose events table to ingest event data and properties. Fulcrum BigQuery Configure Events

  • Review the configuration and Finish setup Fulcrum BigQuery Finish

  • If the token is valid and the connection is successful, you should see a confirmation message indicating that Fulcrum is now connected to BigQuery.

  • At this point, the integration setup is complete, and Fulcrum will start fetching data from BigQuery.

Now, you can create dynamic segments on the real-time data from BigQuery and any additional sources you have connected.