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: Obtain your BigQuery credentials

Step 4: Enter BigQuery Credentials in Fulcrum

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

  • On the BigQuery integration setup screen, you should see relevant fields for the credentials. Fulcrum BigQuery Credentials

  • Paste the credentials you obtained in Step 3 into this field.

  • After confirming the credentials, click on the "Connect BigQuery" button to proceed and allow for access to BigQuery. Fulcrum BigQuery Permissions

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.