The coherent photogalvanic effect leads to the generation of a current under the absorption interference of coherent beams and allows for the inscription of space-charge gratings leading to an effective second-order susceptibility (χ (2) ). The inscribed grating automatically results in quasiphase-matching between the interfering beams. Theoretical and experimental studies have been carried out, mostly focusing on the degenerate case of second-harmonic generation, showing significant conversion efficiency enhancements. However, the link between the theory and experiment was not fully established such that general guidelines and achievable conversion efficiency for a given material platform are still unclear. In this work, we theoretically analyze the phenomenological model of coherent photogalvanic effect in optical waveguides. Our model predicts the existence of non-degenerate sum-frequency generation quasi-phase-matching gratings, which is confirmed experimentally for the first time. In addition, we rigorously formulate the time dynamics of the space-charge grating inscription in coherent photogalvanic process. Based on developed theoretical equations for the time dynamics of the space-charge grating formation, we extract the material parameters governing the process for our experimental platform, stoichiometric silicon nitride. The results obtained provides a basis to compare the performances and potentials of different platforms. This work not only supplements the theory of coherent photogalvanic effect, but also enables us to identify critical parameters and limiting factors for the inscription of χ (2) gratings.