How data is cached during import and validate steps?

Note: I'm not sure I'm reading your post correctly, but please please please do not directly update internal Onestream tables with sql - always use public Onestream API calls. There might be side-effects you are not aware of, and things might get out of sync - if not in the release you're working with, possibly in future ones.

This said, if you have some code executing in your event handlers that doesn't seem to work, post it here and people might be able to help.