I need to move work logging information from Jira into BigQuery for analysis. Specifically, I want to extract timesheet data that shows when work was logged and how many hours were spent on each task. Has anyone found a reliable way to do this data transfer? I’m looking for something that can pull the exact same information you see in Jira’s time tracking reports. The most critical fields I need are the timestamp when logging started and the duration in hours. Any suggestions for tools or methods that work well for this kind of data migration?
I sync Jira timesheet data with BigQuery using the Jira REST API and Python scripts. You need to authenticate to your Jira instance and access the /rest/api/2/worklog/updated endpoint to retrieve the timestamps and duration information. The google-cloud-bigquery library is effective for uploading the processed data. Ensure that you manage errors properly and load data incrementally based on timestamps to prevent duplicates. Additionally, be aware of Jira’s rate limits, which can impact your data retrieval if not monitored.
We did this exact thing last year. Tested a bunch of approaches and ended up with Fivetran’s Jira connector - it’s been rock solid for syncing timesheets. It pulls worklog data (timestamps, time spent) straight into BigQuery tables automatically. Love that it handles schema changes without breaking and keeps the right data types for calculations. Setup took maybe an hour, now we get fresh data every few hours with zero manual work. Only downside is cost, but it’s worth it for our team size - saves tons of maintenance headaches.
zapier’s a great tool for this! you can easily sync jira worklogs with bigquery without code. just set up the connections and map the fields you need, like start dates and logged hours. it does cost a bit, but saves time over coding everything from scratch.