Skip to content
DisputeDashDisputeDash Docs

Export to BigQuery

Connect Google BigQuery to stream your resolved case outcomes into your own data warehouse, so you can build custom reports and blend dispute data with the rest of your analytics.

What you’ll need

Section titled “What you’ll need”

From Google Cloud:

  • Your Project ID
  • A Dataset ID
  • A Table ID (defaults to disputes)
  • A service-account JSON key with permission to write to that BigQuery dataset

Create a service account in Google Cloud with BigQuery write access and download its JSON key.

Connect

Section titled “Connect”
  1. Open the BigQuery configuration in DisputeDash.
  2. Enter the Project ID, Dataset ID, and Table ID.
  3. Paste the service-account JSON.
  4. Select Test to validate the connection.
  5. Save.

Backfilling and ongoing sync

Section titled “Backfilling and ongoing sync”
  • After connecting, use Backfill to export all your historical cases in one pass. Watch the last-synced time to track progress.
  • From then on, won and lost case outcomes are pushed to BigQuery automatically as they’re decided.

Managing the connection

Section titled “Managing the connection”

You can edit the project/dataset/table or toggle the export on and off without re-entering the service-account JSON, and disconnect at any time.