dbt-utils v0.8.5

🚨 deduplicate (#542, #548)

The call signature of deduplicate has changed. The previous call signature is marked as deprecated and will be removed in the next minor version.

The group_by argument is now deprecated and replaced by partition_by.
The order_by argument is now required.
The relation_alias argument has been removed as the macro now supports relation as a string directly. If you were using relation_alias to point to a CTE previously then you can now pass the alias directly to relation.

Before:

{% macro deduplicate(relation, group_by, order_by=none, relation_alias=none) -%}
...
{% endmacro %}

After:

{% macro deduplicate(relation, partition_by, order_by) -%}
...
{% endmacro %}

Add an optional where clause parameter to get_column_values() to filter values returned (#511, #583)
Add where parameter to union_relations macro (#554)
Add Postgres specific implementation of deduplicate() (#548)
Add Snowflake specific implementation of deduplicate() (#543, #548)

Documentation about listagg macro (#544, #560)
Fix links to macro section in table of contents (#555)
Use the ADR (Architectural Design Record) pattern for documenting significant decisions (#573)
Contributing guide (#574)
Add better documentation for deduplicate() (#542, #548)

Fail integration tests appropriately (#540, #545)
Upgrade CircleCI postgres convenience image (#584, #585)
Run test for deduplicate (#579, #580)
Reduce warnings when executing integration tests (#558, #581)
Framework for functional testing using pytest (#588)