Table Of Contents
Table Of Contents

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-20