How does the BigQuery Integration work?

This article explains the warehouse import and warehouse export settings used by Pylon's BigQuery integration. You can install the integration from the BigQuery page.

BigQuery warehouse import reads data from BigQuery and maps the resulting columns onto Account or Contact fields in Pylon. You can select an existing table or write SQL directly.

BigQuery warehouse export writes issue data from Pylon into a BigQuery table. It is a separate setup from warehouse import.

Warehouse Import

Warehouse import is designed to update existing matched records in Pylon. It does not create a new account or contact when a row does not match an existing record.

• Supported destination objects: Accounts and Contacts.
• Matching uses the identifiers you map during setup.
• If a row matches an existing record, the mapped fields are updated on the next sync.
• If a synced field is edited manually in Pylon, the next scheduled import can overwrite that field back to the BigQuery value.

Each import sync runs once per day at its scheduled hour. If you need more than one run per day, you can create multiple import syncs against the same table and schedule them at different hours.

Warehouse Export

Warehouse export writes to a single table that you choose. Pylon creates the table with the required schema and upserts new and updated issue rows into it.

Account and requester or contact details are included as fields on the issues export. They are not exported as separate Accounts or Contacts tables.