Repository navigation
Tags
Tags
Move materializations to dbt_project.yml (#201) * Move materialized='view' out of int_jira__issue_type_parents.sql into dbt_project.yml A config() in the model file takes precedence over dbt_project.yml, so users couldn't override this materialization from their own project. Moving it to dbt_project.yml keeps the view default while letting users override it, e.g. to a table on destinations that don't support views. Fixes #198. Co-Authored-By: Claude Sonnet 5 <noreply@anthropic.com> * Use .changes/ fragment file instead of hand-editing CHANGELOG.md This package doesn't have a .changes/ directory yet, but CHANGELOG.md is meant to be generated by the dbt_package_automations CI pipeline from .changes/{version}.yml once docs:ready is applied, not hand-edited. Co-Authored-By: Claude Sonnet 5 <noreply@anthropic.com> * Document that int_jira__issue_type_parents must stay a view or table dbt_utils.star in int_jira__issue_users needs int_jira__issue_type_parents to exist as a database relation to introspect its columns, so overriding it to ephemeral breaks downstream. Notes this in the model comment, dbt_project.yml, and DECISIONLOG.md so users overriding the materialization know view/table are the only supported options. Co-Authored-By: Claude Sonnet 5 <noreply@anthropic.com> * Drop DECISIONLOG entry for issue_type_parents materialization The model comment and dbt_project.yml comment already cover this; no need for a third copy in DECISIONLOG.md. Co-Authored-By: Claude Sonnet 5 <noreply@anthropic.com> * Generate dbt docs and update CHANGELOG.md via GitHub Actions * Update 1.10.3.yml * Generate dbt docs and update CHANGELOG.md via GitHub Actions * Run dbt v2 CI only on snowflake, bigquery and duckdb Two upstream dbt v2 bugs break this package's v2 run: - databricks: duplicate partition column breaks int_jira__field_history_scd's full refresh (GA-1044229, dbt-labs/dbt#14264) - redshift: view rebuilds fail on the second run (GA-1044262, dbt-labs/dbt#14082) Needs fivetran/solution_analytics#25 (dbt_v2_warehouses) on main; until then the setting is ignored. Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com> * Update int_jira__issue_type_parents.sql * Generate dbt docs and update CHANGELOG.md via GitHub Actions * Generate dbt docs and update CHANGELOG.md via GitHub Actions --------- Co-authored-by: Claude Sonnet 5 <noreply@anthropic.com> Co-authored-by: fivetran-data-model-bot <fivetran-data-model-bot@users.noreply.github.com>
DuckDB support (#195) * Add include_duckdb: true to CI test scenarios * fix: DuckDB compatibility - replace percentile_cont with quantile_cont and fix array cast syntax Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com> * Update README and CHANGELOG * Add check-docs-current.yml and requirements.txt * fix for duckdb 1.11 * fix for duckdb 1.11 * Adds DuckDB as a supported destination. * Update Github Actions * use branch of fivetran_utils * Update Github Actions * Generate dbt docs via GitHub Actions --------- Co-authored-by: Catherine Fritz <111930712+fivetran-catfritz@users.noreply.github.com> Co-authored-by: Claude Sonnet 4.6 <noreply@anthropic.com> Co-authored-by: Jamie Rodriguez <jamie.rodriguez@fivetran.com> Co-authored-by: fivetran-data-model-bot <fivetran-data-model-bot@users.noreply.github.com>
bug/string-limit-bq-sf (#193) * bug/string-limit-bq-sf * fix redshift * redshift and docs * seed for redshift * update seeds for testing * Apply suggestion from @fivetran-savage Co-authored-by: Savage Fivetran <sarah.savage@fivetran.com> * Update CHANGELOG.md * Generate dbt docs via GitHub Actions --------- Co-authored-by: Savage Fivetran <sarah.savage@fivetran.com> Co-authored-by: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
Standardize unioning macros to use fivetran_utils versions (#191) * MagicBot/standardize-unioning-macros * fix spine * fix cte name * fix time for snowflake * fix source rel * fix spine * Generate dbt docs via GitHub Actions * update packages.yml dependency --------- Co-authored-by: Joe Markiewicz <74217849+fivetran-joemarkiewicz@users.noreply.github.com> Co-authored-by: Catherine Fritz <111930712+fivetran-catfritz@users.noreply.github.com> Co-authored-by: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
Feature/add team variable to jira sprint enhanced (#186) * bugfix/remove_null_team_from_sprint_enhanced * revert_integration_yml * adjust_window_function_syntax * Fix formatting in packages.yml * Fix formatting in packages.yml * update_formatting * Generate dbt docs via GitHub Actions * update_cte_formatting * update_cte_formatting * update_yml * Generate dbt docs via GitHub Actions * pre-release/add_team_variable_to_jira_sprint_enhanced * add_inline_comments * bugfix/remove_null_team_from_sprint_enhanced * revert_integration_yml * adjust_window_function_syntax * update_formatting * Fix formatting in packages.yml * Fix formatting in packages.yml * Generate dbt docs via GitHub Actions * update_cte_formatting * update_cte_formatting * update_yml * pre-release/add_team_variable_to_jira_sprint_enhanced * add_inline_comments * rebase_branch_and_update_version * Generate dbt docs via GitHub Actions * update_version * add_comma * Apply suggestions from code review Co-authored-by: Jamie Rodriguez <65564846+fivetran-jamie@users.noreply.github.com> * update_readme * fix_coalesce * Generate dbt docs via GitHub Actions * update_changelog * update_readme * Generate dbt docs via GitHub Actions * Apply suggestions from code review Co-authored-by: Avinash Kunnath <108772760+fivetran-avinash@users.noreply.github.com> * update_yml * Generate dbt docs via GitHub Actions * Apply suggestions from code review Co-authored-by: Avinash Kunnath <108772760+fivetran-avinash@users.noreply.github.com> --------- Co-authored-by: github-actions[bot] <github-actions[bot]@users.noreply.github.com> Co-authored-by: Jamie Rodriguez <65564846+fivetran-jamie@users.noreply.github.com> Co-authored-by: Avinash Kunnath <108772760+fivetran-avinash@users.noreply.github.com>
Release v1.8.0 (#182) * Integrity test sprint investigation (#177) * Integrity test sprint investigation * Revert dbt_project.yml * schema * Bugfix/jira using teams incremental fix (#180) * bugfix/jira_using_teams_incremental_fix * switch to append_new_columns * Apply suggestions from code review --------- Co-authored-by: Savage Fivetran <sarah.savage@fivetran.com> * readme changelog * changelog and on schema change fail * changelog * fix casting * remove on schema change * readme * Uncomment Databricks SQL Warehouse test step * Generate dbt docs via GitHub Actions * Update CHANGELOG.md --------- Co-authored-by: Avinash Kunnath <108772760+fivetran-avinash@users.noreply.github.com> Co-authored-by: Savage Fivetran <sarah.savage@fivetran.com> Co-authored-by: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
PreviousNext