dbt-utils v0.8.1

New features

• A cross-database implementation of any_value() (#497, #501)
• A cross-database implementation of bool_or() (#504)

Under the hood

• add dbt_packages/ to .gitignore #463
• Remove block comments to make date_spine() macro compatible with the Athena connector (#462)

Fixes

• type_timestamp macro now explicitly casts postgres and redshift warehouse timestamp data types as timestamp without time zone, to be consistent with Snowflake behaviour (timestamp_ntz).
• union_relations macro will now raise an exception if the use of include or exclude results in no columns (#473, #266).
• get_relations_by_pattern() works with foreign data wrappers on Postgres again. (#357, #476)
• star() will only alias columns if a prefix/suffix is provided, to allow the unmodified output to still be used in group by clauses etc. #468
• The sequential_values test is now compatible with quoted columns #479
• pivot() escapes values containing apostrophes #503

Contributors:

• grahamwetzler (#473)
• Aesthet (#476)
• Kamitenshi (#462)
• nickperrott (#468)
• jelstongreen (#468)
• armandduijn (#479)
• mdutoo (#503)