dbt v0.25.1

What's Changed

• APP-1316: add BigQuery expiration to elementary test temp tables by @MikaKerman in #1030
• Add Dependency Review GitHub Action by @haritamar in #1031
• Create SECURITY.md by @ofek1weiss in #1033
• feat: derive model/test owners from dbt group owner when no direct owner is set by @arbiv in #1034
• fix: include all failing dimension values in anomaly alert description by @joostboon in #1032

Full Changelog: 0.25.0...0.25.1

dbt v0.25.0

What's Changed

• fix source freshness upload for dbt fusion by @michael-myaskovsky in #1018
• fix: add explicit return(none) in get_elementary_relation when relation not found by @elazarlachkar in #1020
• feat: add elementary_extra_indexes config var for custom index injection by @haritamar in #1019
• added a macro that cleans stale test temp tables. Will be usefull for… by @GuyEshdat in #1022
• docs: Add ClickHouse as compatible with query_id in dbt_run_results by @29antonioac in #1004
• fix: rename get_incremental_microbatch_sql to capture_microbatch_compiled_code_sql by @GuyEshdat in #1024
• perf: eliminate schema_changes_alerts temp table to reduce concurrent DDL by @elazarlachkar in #1025

New Contributors: @29antonioac made their first contribution in #1004

Full Changelog: 0.24.0...0.25.0

dbt v0.24.0

What's Changed

• feat: add min_value parameter for anomaly detection tests by @caterinaandreu in #979
• overriding microbatch macro for capturing the compiled code of the microbatch models by @GuyEshdat in #1000
• fix: handle dbt deferral in get_elementary_relation by @NoyaArie in #1006
• Fix exclude_detection_period_from_training for large time buckets by @devin-ai-integration[bot] in #925
• APP-1086: fix BigQuery nanosecond timestamp cast failure in edr_cast_as_timestamp by @MikaKerman in #1003
• fix: add explicit sqlserver__ dispatch to T-SQL fabric macros (CORE-877) by @elazarlachkar in #1013
• Fixes #991 – Removes unnecessary and broken version check that keeps dbt test description metadata from being captured by @jdglaser in #992
• Defer get_columns_in_relation when no exposures match in exposure_schema_validity by @elazarlachkar in #1014

New Contributors

• @caterinaandreu made their first contribution in #979
• @jdglaser made their first contribution in #992

Full Changelog: 0.23.1...0.24.0

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