If I run:
| inputlookup identities.csv
That shows a different count in the results than
| datamodel("Identity_Management", "All_Identities")
What is going on? I thought I built my indentities.csv correctly.
Take a look at the python_modular_input.log file. This will give you clues as to what is happening. In this case, a field called _time was created and that is not allowed. I saw this error message:
ERROR pid=7888 tid=identity file=lookup_modinput.py:streaming_merge_task:283 | status="Exception when reading input files" exc=Field names cannot start with an underscore: '_time'
Once the field was corrected to not start with an underscore, things worked fine.
View solution in original post