Release Notes
August 2026
v1.0.2
Feature Updates
- Adds DuckDB as a supported destination.
July 2026
v1.0.1
Bug Fixes
- Removes duplicate and malformed documentation block for the
CMDB_CI.unverifiedfield. - Fixes typo in
model_numberfield description.
June 2026
v1.0.0
Schema/Data Changes (--full-refresh required after upgrading)
1 total change • 1 possible breaking change
| Data Model(s) | Change type | Old | New | Notes |
|---|---|---|---|---|
| All models | source_relation column (when using a single servicenow schema) | Empty string ('') | <database>.<schema> |
Feature Updates
- Introduces the new (recommended)
servicenow_sourcesvariable for more robust union data configuration. The oldservicenow_union_schemasandservicenow_union_databasesvariables will still be supported. See the README for specific details.
Under the Hood
- 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. - Introduces
fivetran_utils.partition_by_source_relationto conditionally includesource_relationin partition clauses only when multiple sources are configured.
January 2026
v0.7.0
Schema/Data Changes
2 total changes • 0 possible breaking changes
| Data Model(s) | Change type | Old | New | Notes |
|---|---|---|---|---|
servicenow__task_enhanced | New Column | business_duration_sec | The duration of the task in terms of business time (in seconds). This is the conversion of business_duration from an Epoch timestamp to an integer. | |
servicenow__task_enhanced | New Column | calendar_duration_sec | The duration of the task in terms of calendar time (in seconds). This is the conversion of calendar_duration from an Epoch timestamp to an integer. |
Documentation
- Adds a section to the
DECISIONLOG.mdwith a recommendation for avoiding the manual creation of duplicatesys_choicevalues, per ServiceNow's advised best practices. (#24) - Ensures column types are consistent and accurate in the hosted docs. (#25)
Under the Hood
- Sets explicit
column_typesfor all seed files to ensure data type consistency across data warehouses. (#25) - Streamlines integration test
cmdb_ci_dataandcore_company_dataseed files by removing unused columns to improve test maintainability. (#25)
v0.8.0
Documentation
- Updates README with standardized Fivetran formatting.
Under the Hood
- In the
quickstart.ymlfile:- Adds
table_variablesfor relevant sources to prevent missing sources from blocking downstream Quickstart models.
- Adds
November 2025
v0.5.1
Bug Fix
- Updated joins on
servicenow__task_enhancedto join on theuser_namerather thansys_user_idfield for creator and updater field values.