How is the custom data in unstructured events loaded into Redshift w/ storageloader?


#1

If I’m tracking unstructured events with custom fields, where should I expect to see them in the atomic.events table after running the storageloader utility?


#2

Hi @dyerw,

The custom fields will reside in its own dedicated table. You can join the data with atomic.events via atomic.events.event_id = atomic.your-dedicated-table.root_id

You may find the following article useful to understand how it works. Note unstructured events are also called self-describing events.

Regards,
Ihor


#3

Excellent, this documentation is exactly what I was looking for, thank you.