Exporting Jira Cloud tickets to Google BigQuery

[Bernie J_]

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

[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