v0.7.0-p

What's Changed

• fixing main release action by @venkaa28 in sdf-labs/sdf#4060
• Support for jinja set blocks by @wolfram-s in sdf-labs/sdf#4063
• Expanded tests for date_part by @vgapeyev in sdf-labs/sdf#4048
• More date + interval tests by @vgapeyev in sdf-labs/sdf#4047
• Fix bogus comment by @findepi in sdf-labs/sdf#4013
• Make coerce, can_coerce & friends fallible by @findepi in sdf-labs/sdf#3992
• Updating Cargo Version by @sdf-labs-cicd-app in sdf-labs/sdf#4061
• Compile TPC-DS with Snowflake by @findepi in sdf-labs/sdf#4017
• "Presto" to "Trino" cleanup 2 by @findepi in sdf-labs/sdf#4072
• Disable backtrace for unsupported execution dialect warning by @findepi in sdf-labs/sdf#4075
• Run TPC-DS with Snowflake (some queries failing) by @findepi in sdf-labs/sdf#4067
• Full test runs for daily darwin tests by @sadboy in sdf-labs/sdf#4079
• Enable all TPC-DS Trino execution tests (some fixed, some still failing) by @findepi in sdf-labs/sdf#4076
• Fix Dropping Tokio Runtime in Async, add disable_introspection, and simplify macro templating by @akbog in sdf-labs/sdf#4054
• Enable unused_qualifications rustc lint by @findepi in sdf-labs/sdf#4081
• "Presto" to "Trino" cleanup 3 by @findepi in sdf-labs/sdf#4083
• Zhong/bigquery massive fixes by @wizardxz in sdf-labs/sdf#4057
• jaffle-hell commit 1 by @schulte-lukas in sdf-labs/sdf#4058
• using new build all script to test by @venkaa28 in sdf-labs/sdf#4062
• Fixing cli public endpoints by @venkaa28 in sdf-labs/sdf#4085
• updating deploy workflows by @venkaa28 in sdf-labs/sdf#4087
• slt: Add support for skipif and onlyif records by @gliga in sdf-labs/sdf#4064
• fix actions by @venkaa28 in sdf-labs/sdf#4090
• Implement substr Snowflake function using substring implementation by @findepi in sdf-labs/sdf#4077
• tests: Ensure that workspace directories are not modified by @gliga in sdf-labs/sdf#4089
• Github actions: remove useless checkout in check_changes by @sadboy in sdf-labs/sdf#4095
• sdf build release candidate by @wolfram-s in sdf-labs/sdf#4065
• Additional Deploy Platform with stable patches by @venkaa28 in sdf-labs/sdf#4098
• Added new advanced Snowflake section in docs by @eliasdefaria in sdf-labs/sdf#3926
• Elaborate how compile and run work for YML only tables by @milevin in sdf-labs/sdf#4051

Full Changelog: sdf-labs/sdf@v0.6.0-p...v0.7.0-p

v0.5.11

What's Changed

• Merge pull request #4057 from sdf-labs/zhong/bigquery_massive_fixes by @eliasdefaria in sdf-labs/sdf#4086

Full Changelog: sdf-labs/sdf@v0.5.10...v0.5.11

v0.6.0-p

What's Changed

• slt: Flags cleaned and reflect exactly the set of flags we use by @gliga in sdf-labs/sdf#4019
• Modified check labels to allow documentation by @eliasdefaria in sdf-labs/sdf#4028
• Updating Version by @sdf-labs-cicd-app in sdf-labs/sdf#4027
• slt: fix: Unify local and remote update steps to avoid wrong path by @gliga in sdf-labs/sdf#4023
• Logging fix by @milevin in sdf-labs/sdf#4031
• Enable describe_tpcds_q74 test by @findepi in sdf-labs/sdf#4018
• optimize unicode slice by @wizardxz in sdf-labs/sdf#4032
• Implement casing-policy; remove snowflake_normalized by @sadboy in sdf-labs/sdf#4025
• Fix compile_imdb_snowflake tests; add support for yaml-only-materialization: table by @sadboy in sdf-labs/sdf#4030
• Crate renaming: zxc => sdf-common by @sadboy in sdf-labs/sdf#4050
• Enable DBT database macro execution by @akbog in sdf-labs/sdf#3978
• xtask test: add docs; reclassify dbt_compile tests by @sadboy in sdf-labs/sdf#4055
• Refactor Release Workflows: Preview and Stable Release Enhancements by @venkaa28 in sdf-labs/sdf#4026

Full Changelog: sdf-labs/sdf@v0.5.10...v0.6.0-p

v0.5.10

What's Changed

• Updating Version by @sdf-labs-cicd-app in sdf-labs/sdf#4003
• Enable date_part function for Snowflake, DF-implemented. by @vgapeyev in sdf-labs/sdf#3984
• Some of timestamp_3 column names were probably meant to be timestamp_9 by @vgapeyev in sdf-labs/sdf#4001
• Remove self-referencing links from docs by @findepi in sdf-labs/sdf#3993
• Fix date_part stubs in sdf-frontend tests by @findepi in sdf-labs/sdf#3990
• slt: Fix processing of limit and threshold joinly by @gliga in sdf-labs/sdf#4008
• Enable support for DATE +/- INTERVAL expressions in Snowflake by @vgapeyev in sdf-labs/sdf#3976
• Snowflake TPC-H execution test by @findepi in sdf-labs/sdf#3991
• Use temp table in delete+insert incremental strategy by @milevin in sdf-labs/sdf#4010
• Adapt DataFusion substring UDF for Snowflake. by @vgapeyev in sdf-labs/sdf#3988
• Correcting a few Snowflake function declarations by @vgapeyev in sdf-labs/sdf#3889
• Correctly handle quotes in renaming validation logic by @milevin in sdf-labs/sdf#4022
• Flowers for DBT Jaffle Shop by @akbog in sdf-labs/sdf#3979
• Migrate test_remote_cat to new Task based testing by @akbog in sdf-labs/sdf#4014
• Use arrow-rs fork by @findepi in sdf-labs/sdf#4011
• slt: Support the halt record by @gliga in sdf-labs/sdf#4016
• fix snowflake pivot aggregate function checking by @wizardxz in sdf-labs/sdf#4009
• support snowflake create table clone by @wizardxz in sdf-labs/sdf#4024

Full Changelog: sdf-labs/sdf@v0.5.9...v0.5.10

v0.5.9

What's Changed

• Refactor BQ execute_query to remove a hack by @milevin in sdf-labs/sdf#3974
• Updating Version by @sdf-labs-cicd-app in sdf-labs/sdf#3975
• Upgrade GitHub workflows to use actions running on on current node versions by @findepi in sdf-labs/sdf#3829
• Snowflake imdb compilation and execution test by @schulte-lukas in sdf-labs/sdf#3936
• Snowflake API update ref to main by @akbog in sdf-labs/sdf#3973
• Support BigDecimals and Decimals for remote Bigquery by @milevin in sdf-labs/sdf#3969
• Allow --allow-dirty in xtask clippy and xtask check by @findepi in sdf-labs/sdf#3961
• Improve typing for extract and date_part in Snowflake by @findepi in sdf-labs/sdf#3970
• tests: Add tests for SLT to check if types are getting updated by @gliga in sdf-labs/sdf#3964
• Display file name in the error for invalid CSV files by @milevin in sdf-labs/sdf#3986
• fix coalesce by @wizardxz in sdf-labs/sdf#3977
• fix select star clauses by @wizardxz in sdf-labs/sdf#3985
• Release Channels: Label check enforcement by @venkaa28 in sdf-labs/sdf#3956
• Zhong/fix join scope by @wizardxz in sdf-labs/sdf#3999
• support order by in snowflake over clause and fix join scope by @wizardxz in sdf-labs/sdf#3987

Full Changelog: sdf-labs/sdf@v0.5.8...v0.5.9

v0.5.8

What's Changed

• Introduce current_function_plain_name macro by @findepi in sdf-labs/sdf#3934
• Implement Snowflake regexp_replace function by @findepi in sdf-labs/sdf#3945
• tests: Add tests for the update flag by @gliga in sdf-labs/sdf#3946
• support snowflake unpivot include/exclude null clause by @wizardxz in sdf-labs/sdf#3951
• Lint rules for Trailing Comma Convention revised by @wizardxz in sdf-labs/sdf#3950
• remove substitution unsafe warning by @wizardxz in sdf-labs/sdf#3952
• Migrate compile, exec and slt tests to function name macro by @findepi in sdf-labs/sdf#3953
• Updating Version by @sdf-labs-cicd-app in sdf-labs/sdf#3948
• Verify overlay schema field names by @findepi in sdf-labs/sdf#3954
• Rename {Snowflake,Databricks,Presto,Bigquery,Redshift}Type to Typing by @findepi in sdf-labs/sdf#3962
• cache: don't write data cache for local sources by @sadboy in sdf-labs/sdf#3947
• xtask test -- -f runs only the specified group by @sadboy in sdf-labs/sdf#3958
• slt: Remove wrapper create queries as we pass data via memory by @gliga in sdf-labs/sdf#3935
• Converge utils and utils_copy by @findepi in sdf-labs/sdf#3960
• Init DBT Macro Execution Context by @akbog in sdf-labs/sdf#3971
• slt: Use create or replace tables in slt files by @gliga in sdf-labs/sdf#3972

Full Changelog: sdf-labs/sdf@v0.5.7...v0.5.8

v0.5.7

What's Changed

• Zhong/fmt args by @wizardxz in sdf-labs/sdf#3859
• Add test case "incremental_with_config" by @sadboy in sdf-labs/sdf#3893
• bigquery formatter by @wizardxz in sdf-labs/sdf#3844
• Improve error messaging around schema mismatches; calculate SOT schema code location by @milevin in sdf-labs/sdf#3888
• Updating Version by @sdf-labs-cicd-app in sdf-labs/sdf#3899
• Fix coercion for float = decimal by @findepi in sdf-labs/sdf#3878
• Fix count(NULL) execution by @findepi in sdf-labs/sdf#3896
• fix bigquery bitcoin fmt by @wizardxz in sdf-labs/sdf#3901
• Test and fix Snowflake numerical operators by @findepi in sdf-labs/sdf#3870
• slt: Enforce targeted files/directories are run only even in cases of target failures or parse errors by @gliga in sdf-labs/sdf#3902
• Split Snowflake Connector from sdf-cli by @akbog in sdf-labs/sdf#3900
• Support of config macro for non-indexed directories by @wolfram-s in sdf-labs/sdf#3891
• Fix diff analyzer name in README by @findepi in sdf-labs/sdf#3827
• Re-enable sdf dbt init and add a test by @milevin in sdf-labs/sdf#3916
• fix compile args by @wizardxz in sdf-labs/sdf#3921
• Zhong/bigquery fixes by @wizardxz in sdf-labs/sdf#3917
• fix bigquery timestamp_trunc by @wizardxz in sdf-labs/sdf#3895
• slt: Remove use of global/env variable for passing info about SLTs by @gliga in sdf-labs/sdf#3879
• Ident: quote names with - for Bigquery by @sadboy in sdf-labs/sdf#3922
• download bq prefix table by @wizardxz in sdf-labs/sdf#3925
• Added clickbench snowflake by @schulte-lukas in sdf-labs/sdf#3911
• Fixing all renaming patterns to have an f (not actually z) in front of schema and provide a default test name by @milevin in sdf-labs/sdf#3928
• Wolfram/sdf args by @schulte-lukas in sdf-labs/sdf#3930
• Cache fixes and improvements (detected while developing build) by @wolfram-s in sdf-labs/sdf#3923
• Consolidate sdf-cli integration tests into one crate by @sadboy in sdf-labs/sdf#3924
• SchemaOverlayTableProvider: properly handle filter exprs by @sadboy in sdf-labs/sdf#3937
• Test Snowflake local execution with clickbench queries by @findepi in sdf-labs/sdf#3933
• Correctly format (with dialect) table name in tests by @milevin in sdf-labs/sdf#3931
• Bring back Lint docs by @schulte-lukas in sdf-labs/sdf#3834

Full Changelog: sdf-labs/sdf@v0.5.6...v0.5.7

v0.5.6

What's Changed

• Fix flaky git-lfs behavior by @akbog in sdf-labs/sdf#3894
• Updating Version by @sdf-labs-cicd-app in sdf-labs/sdf#3892
• Fix lime non-deterministic test behavior by @akbog in sdf-labs/sdf#3897
• Resolve SDF Auth Status Snowflake Invalid Identifier Response by @venkaa28 in sdf-labs/sdf#3887

Full Changelog: sdf-labs/sdf@v0.5.5...v0.5.6

v0.5.5

What's Changed

• Error infra: fully converge sdf-frontend by @sadboy in sdf-labs/sdf#3848
• Error infra: kill BinderError 4 (killed!) by @sadboy in sdf-labs/sdf#3845
• Error infra: kIll BinderError 3 by @sadboy in sdf-labs/sdf#3842
• Error infra: kill BinderError 2 by @sadboy in sdf-labs/sdf#3839
• Error infra: kill BinderError 1 by @sadboy in sdf-labs/sdf#3832
• fix slice stop location by @wizardxz in sdf-labs/sdf#3851
• refactor: Move most slt related functions to a single place by @gliga in sdf-labs/sdf#3854
• Fix error message for table schema merge error by @milevin in sdf-labs/sdf#3853
• Updating Version by @sdf-labs-cicd-app in sdf-labs/sdf#3849
• Cleaning up sdf init and initializing dbt by @akbog in sdf-labs/sdf#3814
• Ignoring Tests: Snowflake Login w Username & Password Failed Response Changed by @venkaa28 in sdf-labs/sdf#3861
• Support Quoting Policy for DBT by @akbog in sdf-labs/sdf#3857
• slt: Introduce SLT context to pass relevant data to the computation by @gliga in sdf-labs/sdf#3860
• Don't blank-ignore unsupported SLT directives by @findepi in sdf-labs/sdf#3838
• xtask: fix base_test_set patterns by @sadboy in sdf-labs/sdf#3874
• not eagerly prepare linting when there is no lint rules by @wizardxz in sdf-labs/sdf#3864
• slt: Ensure slt runs are idempotent by @gliga in sdf-labs/sdf#3868
• Split dbt schemas into their own crate by @akbog in sdf-labs/sdf#3862
• tests: Introduce TestResult to carry info back to tests for further checks by @gliga in sdf-labs/sdf#3873
• Expose dbt nodes to sdf-preprocessor by @akbog in sdf-labs/sdf#3863
• Snowflake Key pair: Adding pksc#1 support by @venkaa28 in sdf-labs/sdf#3883
• Extract Auth into sdf-auth crate & cargo machete 🪓 by @akbog in sdf-labs/sdf#3884
• Add snowflake TPCH workspace & compile tests by @schulte-lukas in sdf-labs/sdf#3841
• fix error message for join using by @wizardxz in sdf-labs/sdf#3875

Full Changelog: sdf-labs/sdf@v0.5.4...v0.5.5

v0.5.4

What's Changed

• Test count, min, max, sum with table as source by @findepi in sdf-labs/sdf#3805
• Updating Version by @sdf-labs-cicd-app in sdf-labs/sdf#3821
• DBT Compile Tests by @akbog in sdf-labs/sdf#3775
• Allow --targets-only for non-source specified tables; fix view/table bug by @milevin in sdf-labs/sdf#3824
• Recognize min/max UDF as copy additionally to built-ins by @findepi in sdf-labs/sdf#3826
• Update to DataFusion 41.0.0 by @findepi in sdf-labs/sdf#3628
• Zhong/fix lint fix overlap by @wizardxz in sdf-labs/sdf#3825
• remove linter config by @wizardxz in sdf-labs/sdf#3830
• Remove find_available_port function by @findepi in sdf-labs/sdf#3836
• Enable Snowflake Key-Pair Auth in CLI and Console by @venkaa28 in sdf-labs/sdf#3776
• Fine-grained warehouse specification per table by @milevin in sdf-labs/sdf#3833
• refactor queryNoWith by @wizardxz in sdf-labs/sdf#3835
• Zhong/no cache when compile with warning by @wizardxz in sdf-labs/sdf#3831

Full Changelog: sdf-labs/sdf@v0.5.3...v0.5.4