Table Of Contents
Table Of Contents

2023-07-18 - Coalesce user defined event keys


Status: Available

Type: DataOps

Date: 2023-07-18


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.

Last Refreshed

Doc Refreshed: 2023-11-23