{"repo":"fivetran/dbt_jira","free":true,"listed":false,"github":"https://github.com/fivetran/dbt_jira","clone":"git clone https://github.com/fivetran/dbt_jira.git","description":"Data models for Fivetran's Jira connector built using dbt.","language":null,"stars":13,"topics":["dbt","fivetran","dbt-packages","jira"],"license":"Apache-2.0","category":"data-pipelines","readme_excerpt":"Jira dbt Package This dbt package transforms data from Fivetran's Jira connector into analytics-ready tables. Resources - Number of materialized models¹: 48 - Connector documentation - Jira connector documentation - Jira ERD - dbt package documentation - GitHub repository - dbt Docs - DAG - Changelog - dbt Core™ supported versions - =1.3.0, Example Analytics Questions: How many issues, by sprint, were Closed or Blocked each week in Q1, 2025? How many days, on average, does it take an issue to go from 'Accepted' to either 'Closed' or 'Blocked'? jira timestamp issue field history Table tracking field changes at timestamp level with validity periods. Each record shows complete field state during a time period with valid from / valid until timestamps. For an example of how this data can be used, see this analysis query, which demonstrates building an issue transition cumulative flow analysis. Example Analytics Questions: What was the exact sequence of field changes for a specific issue? How long did an issue spend in each status with precise timing? jira issue status transitions Issue status transition tracking with workflow analysis. Provides chronological view of status changes with timing metrics, transition direction analysis, and lifecycle indicators. Example Analytics Questions: What is the average time spent in each status across all issues? Which is the lead time and cycle time for issues based on when work is added/started/completed? What are the most common workflow tra","default_branch":null,"files":null,"tree":[],"storefront":"/r/fivetran","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/fivetran/dbt_jira/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}