Release Notes
August 2026
We've updated the following quickstart data model packages to add DuckDB as a supported destination:
Expand to see full list
- Ad Reporting to version v2.7.3
- Amazon Ads to version v1.3.1
- Amazon Selling Partner to version v0.5.1
- Amplitude to version v1.4.1
- App Reporting to version v1.3.2
- Apple App Store to version v1.3.2
- Apple Search Ads to version v1.3.1
- Asana to version v1.4.1
- AWS Cloud Cost to version v0.4.1
- Facebook Ads to version v1.5.1
- Facebook Pages to version v1.3.1
- Fivetran Platform Connector to version v2.5.3
- GitHub to version v1.4.1
- Google Ads to version v1.4.1
- Google Analytics 4 Export to version v0.7.2
- Google Play to version v1.3.1
- Greenhouse to version v1.4.1
- HubSpot to version v1.9.2
- Instagram Business to version v1.2.1
- Intercom to version v1.7.1
- Iterable to version v1.5.1
- Jira to version v1.10.2
- Klaviyo to version v1.4.1
- Lever to version v1.3.1
- LinkedIn Ad Analytics to version v1.3.1
- LinkedIn Company Pages to version v1.5.1
- Mailchimp to version v1.3.2
- Marketo to version v1.4.1
- Microsoft Advertising to version v1.3.1
- Microsoft Dynamics 365 CRM to version v0.4.1
- Mixpanel to version v0.17.1
- NetSuite SuiteAnalytics to version v1.7.1
- Pardot to version v1.4.1
- Pendo to version v1.4.1
- Pinterest Ads to version v1.3.1
- Qualtrics to version v1.3.1
- QuickBooks to version v1.9.1
- Recharge to version v1.5.2
- Recurly to version v1.5.1
- Reddit Ads to version v1.5.1
- Sage Intacct to version v1.4.1
- Salesforce to version v2.4.1
- Salesforce Marketing Cloud to version v0.6.1
- SAP to version v0.8.1
- ServiceNow to version v1.0.2
- Shopify to version v1.9.2
- Shopify Holistic to version v1.3.1
- Snapchat Ads to version v1.3.1
- Social Media Reporting to version v1.6.2
- StackAdapt to version v0.2.1
- Stripe to version v1.10.1
- TikTok Ads to version v1.4.1
- Twilio to version v1.4.1
- Unified RAG to version v0.3.1
- Workday HCM to version v1.0.3
- X Ads to version v1.3.1
- X Organic to version v1.2.1
- Xero to version v1.6.1
- YouTube Analytics to version v1.2.1
- Zendesk Support to version v1.7.1
- Zuora to version v1.4.1
June 2026
v1.10.1
Bug Fix
- Fixes a runtime error on Snowflake and BigQuery that occurred when an issue's concatenated comments exceeded the warehouse's string length limit. The
conversationfield injira__issue_enhancednow returns'conversation too long to render'for those issues instead of failing the entire run.count_commentsis unaffected. The character threshold defaults to 16,777,216 (16MB) but can be lowered using thejira_conversation_char_limitvariable. See the README for configuration details and the DECISIONLOG for per-warehouse details.
v1.10.0
Under the Hood
- Migrates the
union_connections,apply_source_relation, andpartition_by_source_relationmacros to thedbt_fivetran_utilspackage. - Adds the
fivetran_using_source_casingvariable for case-sensitive destination support. When enabled, downstream transformations respect source casing to ensure consistent results. See the Additional Configurations section of the README for details.
May 2026
v1.9.0
Feature Update
Adds configurable table variable
Include Team Dimension in Sprint Enhancedto control whether theteamcolumn is included injira__sprint_enhanced. Variable is set totrueby default. When set tofalse, the table rolls up to one row per sprint with all metrics aggregated at the sprint level. Only applicable if theteamtable is synced in your connector.For dbt Core users: Introduces
jira_sprint_enhanced_include_teamsvariable to control whether the team dimension is included injira__sprint_enhanced. This variable only applies whenjira_using_teamsis also enabled. See the README on how to configure this variable.
Bug Fix
- Fixes an issue in
jira__sprint_enhancedwhereoriginal_estimate_seconds,remaining_estimate_seconds, andtime_spent_secondswere undercounted when multiple issues in the same sprint shared identical estimate values. The model now correctly sums estimates per issue before aggregating to the sprint level.
April 2026
v1.8.0
Bug Fix
- For warehouses using the
insert_overwritestrategy, updates the incremental filter injira__daily_issue_field_historyto align with the model’s partition grain. This helps prevent issues with incomplete partition coverage.- You must run a
--full-refreshafter upgrading to apply this fix to existing data.
- You must run a
Under the Hood
- Updates integrity test for
jira__daily_sprint_issue_historyto track the last sprint-related event per day, ensuring that only sprint IDs recorded at the final event timestamp for each issue/day are included.
March 2026
v1.7.0
Schema/Data Change (--full-refresh required after upgrading)
3 total changes • 3 possible breaking changes
| Data Model(s) | Change type | Old | New | Notes |
|---|---|---|---|---|
jira__daily_issue_field_history jira__daily_sprint_issue_history jira__issue_enhanced | Removed default columns (Breaking Change) | story_points and story_point_estimate included by default | Columns only included when added to var('issue_field_history_columns') | These fields are Scrum-specific custom fields not universally used. Add the relevant fields to the issue_field_history_columns variable to retain them. |
jira__sprint_enhanced | Removed default columns (Breaking Change) | story_points_committed, story_points_end, story_points_completed, story_point_estimate_committed, story_point_estimate_end, and story_point_estimate_completed included by default | Columns only included when story points and/or story point estimate are added to var('issue_field_history_columns') | These metrics depend on story_points/story_point_estimate being tracked in field history. Add the relevant fields to the issue_field_history_columns variable to retain them. |
jira__daily_sprint_issue_history jira__sprint_enhanced | Column type change | story_points and story_point_estimate cast as float | Cast as numeric | Improves precision for fractional story point values. |
Bug Fix
- Updated
stg_jira__sprintto filter out soft-deleted sprint records using the_fivetran_deletedflag.
Under the Hood
- Adds a new
convert_string_to_numericmacro with warehouse-specific dispatch implementations to safely cast story point string values to numeric, handling edge cases such as comma-formatted numbers.
Documentation
- Updates model descriptions to remove static documentation for
story_points,story_point_estimate, andteamcolumns. Removes story point-related column documentation fromjira__sprint_enhancedas these columns are dynamic and only present when added tovar('issue_field_history_columns').- To retain story point data, add
story pointsand/orstory point estimateto theissue_field_history_columnsvariable in yourdbt_project.yml(See the README for details). Quickstart users can add these fields in the Issue Field History Columns setting.
- To retain story point data, add
v1.6.0
Schema/Data Change (--full-refresh required after upgrading)
1 total change • 1 possible breaking change
| Data Model(s) | Change type | Old | New | Notes |
|---|---|---|---|---|
jira__daily_issue_field_history | Incremental filter fix (Breaking Change) | Filtered by date_day >= max_date_week | Filtered by date_week >= max_date_week | Aligns the incremental filter with the model's weekly partition key. The previous filter could cause data loss during partition overwrites in BigQuery and Databricks destinations on incremental runs. could cause data loss during partition overwrites on incremental runs. A full refresh is recommended to backfill any records that may have been missed. |
v1.5.2
Documentation
- In the
quickstart.ymlfile:- Made several corrections to Quickstart
supported_varsdescriptions to reflect correct time granularity forjira_issue_history_bufferandlookback_windowvariables.
- Made several corrections to Quickstart
February 2026
v1.5.1
Feature Update
- Optimizes the
jira__daily_sprint_issue_historymodel for Databricks destinations by adjusting thesplit_sprint_ids()macro.
Under the Hood
- Adjusts the vertical integrity
jira__daily_sprint_issue_historytest to incorporate the sprint start date.
v1.5.0
Schema/Data Change (--full-refresh required after upgrading)
5 total changes • 3 possible breaking changes
| Data Model(s) | Change type | Old | New | Notes |
|---|---|---|---|---|
jira__daily_sprint_issue_history | Date range (Breaking Change) | From the start of the sprint to the last day an issue was added to it | From the start of the sprint to its end | Initially, model incorrectly tracked issues after being removed from sprint or days missing in sprint when issues were added early. Extends tracking period to full sprint lifecycle, creating additional daily records and changing historical data structure. If no end date is provided, sprints will be tracked up to the current date. PR #169 |
jira__daily_sprint_issue_history | Removed column (Breaking Change) | Included updated_at column | Column removed | Previously model tracked timestamp when sprint assignment was updated. New logic uses sprint date ranges instead of tracking individual update events. PR #169 |
jira__daily_issue_field_history | New column (Breaking Change) | Tracked sprint (sprint IDs) as a default field. | Now also tracks sprint_name (sprint names) | Provides human-readable sprint names alongside sprint IDs. PR #162 |
jira__timestamp_issue_field_history | New columns | Only tracked status as a default field | Now tracks sprint (sprint IDs), sprint_name (sprint names) as default fields alongside status | Brings timestamp model closer to parity with daily model. Story points fields are configurable via issue_field_history_columns variable. PR #162 |
jira__daily_sprint_issue_historyjira__sprint_enhanced | New column | team | Adds team column. You can disable team functionality by leveraging the jira_using_teams variable in dbt Core (Quickstart will handle enable/disable automatically). See the README for configuration details. PR #163 |
Bug Fixes
- Fixes compilation errors in
int_jira__pivot_daily_field_history,int_jira__pivot_timestamp_field_historywhensprintorsprint_namewere included in theissue_field_history_columnsvariable.int_jira__timestamp_field_history_scdalso handles this logic, along withstory_pointsandstory_point_estimate. These fields are now properly excluded from the custom columns loop since they're handled as default fields. PR #162 - Optimizes joins in
jira__daily_sprint_issue_historyto allow for quicker full refresh runs. PR #169
Under the Hood
- Creates
split_sprint_ids()macro to unnest thejira__daily_issue_field_history.sprintfield. PR #169 - Adjusts the issue field history null placeholder from
is_nullto-is_nullfor more consistent aggregations. PR #169
Documentation
- Adds missing field descriptions.
January 2026
v1.4.0
Documentation
- Updates README with standardized Fivetran formatting.
- Removes duplicative column yml definitions.
Under the Hood
- In the
quickstart.ymlfile:- Adds
table_variablesfor relevant sources to prevent missing sources from blocking downstream Quickstart models. - Adds
supported_varsfor Quickstart UI customization.
- Adds
December 2025
v1.3.1
Bug Fixes
- Ensures that issues in
jira__issue_enhancedproperly reflect their current sprint assignments. Previously, if an issue was assigned to a sprint and later unassigned (leaving it with no sprint), the old sprint would persist as the issue'scurrent_sprint_nameandcurrent_sprint_id.
Test Updates
- Fixes
vertical_integrity_sprint_enhancedtest to filter out deleted issues (as done instg_jira__issue) to align source/end model issue counts by sprint. - Excludes more fields that are aggregated strings with non-deterministic orders to the exclude columns set in
consistency_issue_enhanced.
August 2025
v1.0.0
Breaking Changes
Source Package Consolidation
- Removed the dependency on the
fivetran/jira_sourcepackage.- All functionality from the source package has been merged into this transformation package for improved maintainability and clarity.
- If you reference
fivetran/jira_sourcein yourpackages.yml, you must remove this dependency to avoid conflicts. - Any source overrides referencing the
fivetran/jira_sourcepackage will also need to be removed or updated to reference this package. - Update any jira_source-scoped variables to be scoped to only under this package. See the README for how to configure the build schema of staging models.
- As part of the consolidation, vars are no longer used to reference staging models, and only sources are represented by vars. Staging models are now referenced directly with
ref()in downstream models.
dbt Fusion Compatibility Updates
- Updated package to maintain compatibility with dbt-core versions both before and after v1.10.6, which introduced a breaking change to multi-argument test syntax (e.g.,
unique_combination_of_columns). - Temporarily removed unsupported tests to avoid errors and ensure smoother upgrades across different dbt-core versions. These tests will be reintroduced once a safe migration path is available.
- Removed all
dbt_utils.unique_combination_of_columnstests. - Moved
loaded_at_field: _fivetran_syncedunder theconfig:block insrc_jira.yml.
- Removed all
Under the Hood
- Updated conditions in
.github/workflows/auto-release.yml. - Added
.github/workflows/generate-docs.yml.