check for missing properties and defer to CQL if needed