dbt v0.23.1

What's Changed

• fix: fix replace_table_data broken on multiple adapters (Trino, Redshift, etc.) by @devin-ai-integration[bot] in #969
• feat: add BigQuery partitioning and clustering to data_monitoring_metrics by @devin-ai-integration[bot] in #972
• Add data_freshness_sla and volume_threshold tests by @joostboon in #932
• feat: add show_sample_rows tag and extend PII protection to model, column, and test level by @joostboon in #973
• feat: add _with_context variants for generic tests by @joostboon in #975
• Fixed macro calling by @ofek1weiss in #984

Full Changelog: 0.23.0...0.23.1

0.23.0

What's Changed

• Fix breaking changes in recent dbt-fusion version by @devin-ai-integration[bot] in #920
• feat: make override_primary_test_model_id Fusion compatible by @devin-ai-integration[bot] in #930
• feat: add DuckDB support with macro dispatches and CI configuration by @devin-ai-integration[bot] in #935
• feat: add full ClickHouse support - remove all skip_targets markers (CORE-397) by @devin-ai-integration[bot] in #934
• fix: add Trino and Spark adapter support for create_table_as and full_name_split by @devin-ai-integration[bot] in #948
• feat: add dremio__target_database dispatch macro by @devin-ai-integration[bot] in #952
• fix: add row_number and snapshots to Dremio reserved keywords list by @devin-ai-integration[bot] in #955
• fix: copy dbt-origin dicts before mutation to fix fusion preview.134+ regression by @devin-ai-integration[bot] in #959
• fix: add Dremio-specific edr_dateadd and improve edr_cast_as_timestamp by @devin-ai-integration[bot] in #957
• fix: add Athena-specific edr_drop_schema and always-run schema cleanup step by @devin-ai-integration[bot] in #960
• feat: add Microsoft Fabric DWH integration (ELE-5282) by @devin-ai-integration[bot] in #962
• Fix test result sample count differing from failure count by @MikaKerman in #933
• add option to partition large models by @rrbarbosa in #939
• feat: add Vertica adapter support by @jc00ke in #963
• feat: add dbt-fabricspark adapter support (ELE-5295) by @devin-ai-integration[bot] in #964
• fix: include fabricspark in delta file_format config for integration tests by @devin-ai-integration[bot] in #967
• feat: opt-in config to filter artifacts to current project only by @cedric-orange in #968

New Contributors

• @MikaKerman made their first contribution in #933
• @rrbarbosa made their first contribution in #939
• @jc00ke made their first contribution in #963
• @cedric-orange made their first contribution in #968

Full Changelog: 0.22.1...0.23.0

dbt v0.22.1

What's Changed

• release/0.22.1 by @github-actions[bot] in #922

Full Changelog: 0.22.0...0.22.1

0.22.0

What's Changed

• Fix: deleting redshift test temp tables without a transaction because reds… by @GuyEshdat in #901
• Extract test owner from primary model only by @arbiv in #905
• Enable test_sample_row_count config on tests by @Ryosuke839 in #903
• Test result data to include row index and test type information for each result by @haritamar in #908
• Add execution_sla test to verify pipeline runs before deadline by @joostboon in #912
• Add Elementary component to query metadata by @elazarlachkar in #913
• Add ClickHouse cluster support, part 2 by @StevenReitsma in #904
• fix: handle fractional day conversion for hour-based detection periods by @joostboon in #914
• Pin dbt-fusion version to 2.0.0-preview.76 to fix CI failures by @devin-ai-integration[bot] in #917
• Fix: use named volume for ClickHouse to avoid permission issues in CI by @devin-ai-integration[bot] in #916
• Fix: normalize rows_affected to handle string values from dbt-databricks by @devin-ai-integration[bot] in #915
• fix: set explicit incremental_strategy='append' for test_result_rows.sql by @devin-ai-integration[bot] in #918

New Contributors

• @Ryosuke839 made their first contribution in #903
• @joostboon made their first contribution in #912

Full Changelog: 0.21.0...0.22.0

dbt v0.21.0

What's Changed

• Redshift: Removed transaction from delete and insert queries by @GuyEshdat in #899
• Dremio: Removed micro/nano seconds by @GuyEshdat in #874
• Raise error if columns can't be detected by @kokorin in #881
• Add exclude_detection_period_from_training flag to volume_anomalies test by @arbiv in #877
• Render jinja template for table_filter in dump_table by @haritamar in #879
• Made the description of the anomaly test more accurate by @GuyEshdat in #883
• Bump package compatibility version by @SoloJ in #893
• Add exclude_detection_period_from_training flag to event freshness anomaly tests by @devin-ai-integration[bot] in #888
• Make Elementary work with ClickHouse cluster mode by @StevenReitsma in #878
• Fix CVE-2023-45803 and CVE-2024-37891 by updating urllib3 constraint by @devin-ai-integration[bot] in #886
• Add exclude_detection_period_from_training flag to freshness anomaly tests by @devin-ai-integration[bot] in #885
• Add exclude_detection_period_from_training flag to column anomalies tests by @devin-ai-integration[bot] in #889
• Add exclude_detection_period_from_training flag to dimension anomaly test by @devin-ai-integration[bot] in #890
• Changed failures and affected_rows fields to be bigint in schema by @GuyEshdat in #898
• CI - restrict postgres version by @haritamar in #880
• Created stale configuration for issues and PRs by @arbiv in #887
• Rebrand README by @NoyaOffer in #896

New Contributors

• @SoloJ made their first contribution in #893

Full Changelog: 0.20.1...0.21.0

0.20.1

What's Changed

• is_dbt_fusion: check that the major is exactly 2 by @haritamar in #870
• release/0.20.1 by @github-actions[bot] in #872

Full Changelog: 0.20.0...0.20.1

0.20.0

What's Changed

• Use select instead of models by @ofek1weiss in #853
• added indices to improve loading time by @arbiv in #852
• Fix datetime casting macro for ClickHouse by @StevenReitsma in #851
• only require approvals on PRs from forks by @haritamar in #854
• require approvals on any PRs from forks regardless of the trigger by @haritamar in #857
• only check if fork on pull requests by @haritamar in #863
• Index test_result_rows.detected_at column by @elazarlachkar in #862
• Fix Athena DROP TABLE parsing error with backtick quoting by @devin-ai-integration[bot] in #861
• Dremio: Formatting timestamp column by @elazarlachkar in #865
• get_user_creation_query: include metadata permissions for dremio by @haritamar in #866
• esacped more dremio special chars by @GuyEshdat in #860
• Ele 4724 dbt fusion support by @haritamar in #825
• Ele 5121 dremio fix for replace table data by @haritamar in #868
• Ele 5120 fusion databricks bugfix by @haritamar in #867
• release/0.20.0 by @github-actions[bot] in #869

New Contributors

• @StevenReitsma made their first contribution in #851
• @elazarlachkar made their first contribution in #862

Full Changelog: 0.19.4...0.20.0

dbt v0.19.4

What's Changed

• Ele 4942 dimension anomalies visualization by @NoyaArie in #847

Full Changelog: 0.19.3...0.19.4

dbt v0.19.3

What's Changed

• added dremio data_type_list by @GuyEshdat in #843
• Ele 4931 dremio types mapping by @GuyEshdat in #844
• dbt-fusion fix: meta under config in dbt_run_results by @haritamar in #845
• release/0.19.3 by @github-actions[bot] in #846

Full Changelog: 0.19.2...0.19.3

dbt v0.19.2

What's Changed

• Ele 4774 update tests quality dimension by @NoyaArie in #826
• run_query: add metadata comment to all queries run with elementary.run.query by @haritamar in #828
• snowflake user creation - use public key by @haritamar in #827
• add runtime log to dbt package by @ofek1weiss in #829
• Add configuration to disable sample collection for PII tables by @devin-ai-integration[bot] in #831
• Implement column-level PII protection for sample collection by @devin-ai-integration[bot] in #833
• Ele 4874 dremio by @GuyEshdat in #838

New Contributors

• @devin-ai-integration[bot] made their first contribution in #834

Full Changelog: 0.19.1...0.19.2