2023-07-18 - Coalesce user defined event keys¶
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)
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.
Doc Refreshed: 2023-11-23