BigQuery Data Source Support

Connect to Google BigQuery as a data source alongside Snowflake, PostgreSQL, and Databricks. Organizations using BigQuery can now leverage Bobsled AI's natural language to SQL capabilities against their BigQuery projects using GCP Workload Identity Federation for secure, keyless authentication.

What's New

• Connect to one or more BigQuery projects using GCP Workload Identity Federation (WIF)
• Run SQL queries against BigQuery datasets with full support for BigQuery's 3-level namespace (project.dataset.table)
• Test connections before saving data source configuration, with detailed reporting of accessible projects and datasets
• Automatic backtick-quoting of identifiers containing special characters (e.g., project IDs with hyphens)
• SQL editor support for backtick-quoted identifiers with correct syntax highlighting

New Data Source Type

The type field in data source endpoints now accepts bigquery in addition to snowflake, postgres, databricks, and sledhouse.

Modified Endpoints

Test Connection (Stateless)

POST /api/v1/accounts/{accountId}/data-sources/test-connection

Now accepts BigQuery connection configuration:

{
  "connectionConfig": {
    "type": "bigquery",
    "projectIds": ["my-gcp-project", "another-project"],
    "defaultLocation": "US"
  }
}

Test Connection (Existing Data Source)

POST /api/v1/accounts/{accountId}/data-sources/{id}/test-connection

Works with saved BigQuery data sources.

Data Product Schema

GET /api/v1/accounts/{accountId}/data-sources/{id}/data-products/{dataProductId}/schema

Now supports BigQuery data sources for fetching table column definitions.

Response Format

Connection test response for BigQuery:

{
  "ok": true,
  "data": {
    "success": true,
    "message": "Successfully connected to BigQuery",
    "details": {
      "type": "bigquery",
      "accessibleProjects": ["my-gcp-project"],
      "accessibleDatasets": {
        "my-gcp-project": ["analytics", "raw_data", "staging"]
      },
      "serviceAccountEmail": "[email protected]"
    }
  }
}

Getting Started

1. Grant the Bobsled service account BigQuery Data Viewer and BigQuery Job User roles on your GCP project(s)
2. Navigate to Data Sources, click Add New, then select BigQuery
3. Enter your project ID(s) and optional default location
4. Test the connection to verify accessible projects and datasets
5. Save the data source configuration