Add BigQuery to Fulcrum

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

On the integration page, look for the BigQuery integration.
Once you find the BigQuery integration, click on the "Connect". This will initiate the integration setup.

Open a new tab in your web browser and go to the BigQuery console (opens in a new tab).
Log in to your BigQuery account.
After logging in, navigate to the API & Services > Credentials.
Create New OAuth Client ID credentials
Fill in the form including the Redirect URI as shown below
- Redirect URI: https://api.getfulcrum.io/sources/bigquery/auth/callback (opens in a new tab)
Copy the generated BigQuery Client ID and Client Secret to your clipboard. Also, note down your project ID. Now, head back to 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.
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.

Select BigQuery Dataset to use for Fulcrum
Choose User table to ingest user properties. Select a unique user ID column.
Choose Organization table to ingest org properties. Select a unique org ID column.
Finally, choose events table to ingest event data and properties.
Review the configuration and Finish setup
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.