Connect BigQuery

All connectors · Checked against AXO’s implementation in October 2026.

Prepare access

Use an owner or admin account in AXO and confirm the selected site. Have permission to authorize the external account or create its server credentials. Keep secrets in the connector’s protected configuration.

Connect

The current catalog form does not expose the full configuration for this connector. Use Advanced setup below before completing these steps.

1. Create a trigger, select this integration as its destination, and render the provider’s expected payload in its template. Selecting Events to forward alone does not invoke this native trigger adapter.
2. Grant the service account access to insert rows in this table. Make the trigger JSON match its column schema.

Verify the result

The check exchanges a signed service-account assertion for a token. It does not verify table existence or insert permission.

Record the AXO integration or trigger result and the receiving system’s result. A saved configuration, credential check, and completed delivery establish different things. Use a controlled destination for a test that writes data or sends a message.

Fix a failed connection

Inspect insertErrors as well as HTTP status. A 200 insertAll response can still reject the row. Check field names/types and service-account permissions.

For a saved catalog connector, open Health to read the latest error, then repair the settings through the setup method on this page. Pause delivery while correcting an unintended destination. Reconnect OAuth when its grant is revoked; for key-based connections, save the replacement key, verify it, then revoke the old key at the provider.

Advanced setup with an AXO MCP client

1. Connect the AXO MCP server with write access to the intended site. The authenticated account must have owner/admin permission.
2. Call create_integration with the type below and a config object using the exact field names above. Start with active: false and no event subscriptions. Supply credential values through your protected tool configuration.
3. Keep the returned integration ID. Use update_integration for corrections rather than creating duplicates.
4. Complete any authorization steps above, configure the trigger or source, and perform the verification described here. Source imports need the integration enabled before scheduled synchronization can run. Use test_integration only if this guide describes a supported test.
5. Use update_integration with the returned integration_id and active: true to enable the integration after checking its external account and payload. Enable the intended trigger separately. Copy expected_revision from the latest get_integration read when one is returned.

{
  "type": "bigquery",
  "config": {
    "project_id": "REPLACE_WITH_YOUR_VALUE",
    "dataset_id": "REPLACE_WITH_YOUR_VALUE",
    "table_id": "REPLACE_WITH_YOUR_VALUE",
    "service_account_json": "REPLACE_WITH_YOUR_VALUE"
  },
  "events": [],
  "active": false
}

The example is a configuration checklist. Replace placeholders and omit optional or inapplicable fields before calling the tool. A dry run previews the request but does not validate provider access.

Next: create an event-triggered action, or implement a webhook receiver.