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-05-23