Exporting Jira Cloud tickets to Google BigQuery

[Bernie J_]

I see connectors for Jira on prem but not for Jira Cloud. Any suggestions? 

[Freemetrics]

I'm the founder of FreeMetrics and we ship an app in exactly this category — weigh my bias accordingly.

Since this thread still ranks for "Jira Cloud to BigQuery" five years on, here's the 2026 state of the options for anyone landing here from search:

1. General ETL platforms (Skyvia, Talend, Boomi, Fivetran, Airbyte) — still the right call when Jira is one of many sources feeding a warehouse you already run. Costs are row/credit-based, and Jira-specific modelling — changelog semantics, sprints, deletions — stays on you.

2. REST API scripts — they work, but the standing-pipeline parts are the hard 20%: pagination, the points-based rate limit Jira Cloud now enforces, deleted worklogs, custom-field typing, and the reconciliation you write after the first "why don't these numbers match Jira" incident.

3. Marketplace connectors — the BigQuery Connector mentioned above by Anna is the long-standing option. Ours is the new one (approved this month): BigQuery Sync for Jira runs on Atlassian Forge inside your Jira site and writes straight to a BigQuery dataset you own — the manifest permits egress only to bigquery.googleapis.com, so no vendor servers ever touch your data. Syncs every 5 minutes with full changelog, worklogs and sprints, plus ready-made views (time in status, sprint report, cycle times). Free forever for sites of 10 users or fewer, so trying the BigQuery route costs nothing: https://marketplace.atlassian.com/apps/4177948694/bigquery-sync-for-jira

Whichever route you take: sync the changelog (not just issues), keep history append-only, and record deletions — otherwise the dashboard will never quite match Jira and nobody will trust it.

[Robin Kon]

Hello @Bernie J_,

There are many tools available to solve this problem. You can pay attention to Skyvia, Talend, and Boomi. Personally, I use the first tool, as it is the easiest to set up and the cheapest one.

Hope it helps

[Anna Odrynska - Alpha Serve]

Hi @Bernie J_ 

I see that`s it's been a while since you've asked this question, but if you still need to know about all Jira Cloud to BigQuery integrations, you can keep in mind our BigQuery Connector for Jira which is also available for Cloud. 

Anna

[Dirk Ronsmans]

Hey @Bernie J_ ,

I'm unfamiliar with the source possibilities of BigQuery but I think your best bet will be to use a REST API as the source.

I can see in the documentation that JSON is a valid format for loading data in Batched loading

https://cloud.google.com/bigquery/docs/loading-data

So using the REST API of your cloud environment might be something to explore.

https://developer.atlassian.com/cloud/jira/platform/rest/v3/intro/

[Bernie J_]

Thanks so much Dirk. Will check that out