An update was made to the identities.csv and now I'm not seeing the expected result count. What is going on?

[DerekB]

If I run:

| inputlookup identities.csv

xxxx results

That shows a different count in the results than

| datamodel("Identity_Management", "All_Identities")

yyyy results

What is going on? I thought I built my indentities.csv correctly.

[DerekB · Accepted solution]

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.