.. _2023-07-18-coalesce-user-defined-event-keys_release:

=================================================================================
2023-07-18 - Coalesce user defined event keys
=================================================================================

Release
==================
*Status: Available*

*Type: DataOps*

*Date: 2023-07-18*

Problem
==================
Currently, all auto generated primary keys are automatically created as COALESCE([column],'UNKNOWN') ... but user defined output event keys (for concepts) aren't, so if null values flow through them the key is created with a 'null' value (which we don't what happening)

Solution
==================
Update the Output Keys pattern to include the coalesce statement

Leverage the Magic
====================================
Extend the jinja template to use the same coalesce pattern for any _key columns , whether autogenerated or user defined.

Last Refreshed
===========================
*Doc Refreshed: 2024-03-02*