BigQuery — Integration

Overview

Sync conformed datasets to Google BigQuery and optionally read external tables into InsightLake dashboards.

Capabilities

• Service Account JSON auth with scoped permissions

• Dataset auto-provisioning and partitioning (by date)

• Incremental merges with configurable keys

• Query pass-through for advanced analyses

1. 1

   Step 1

   Create a Service Account with BigQuery Data Editor (writer) and/or Viewer (reader).

   Back to top
2. 2

   Step 2

   Upload the JSON key in InsightLake → Connections → BigQuery.

   Back to top
3. 3

   Step 3

   Select projects/datasets and map InsightLake tables to target datasets.

   Back to top
4. 4

   Step 4

   Choose full/incremental mode and schedule.

   Back to top
5. 5

   Step 5

   Test sync and validate row counts in BigQuery.

   Back to top

Limitations

• Streaming inserts may be buffered to optimize cost/quotas.

• Reader mode enforces read-only; writes are disallowed from SQL console.

FAQs

Pricing