Sony A7R III has a 42.0MP Full frame (35.9 x 24 mm ) sized BSI-CMOS sensor and features Bionz X processor. On the other hand, Sigma SD9 has a 3.0MP APS-C (20.7 x 13.8 mm ) sized CMOS (Foveon X3) sensor .
Sony A7R III's sensor provides 39MP more than Sigma SD9's sensor, which gives a significant advantage in real life. You can print your images larger or crop more freely.
On the other hand, please keep in mind that Max sensor resolution is not the only determinant of resolving power. Factors such as the optical elements, low pass filter, pixel size and sensor technology also affects the final resolution of the captured image.
Another similarity between these two cameras is that both Sigma SD9 and Sony A7R III sensors lack anti-alias (Low-Pass) filters. Removing anti-alias filter increases the sharpness and level of detail but at the same time, it increases the chance of moire occurring in certain scenes.
Below you can see the A7R III and SD9 sensor size comparison.
As seen above, Sony A7R III has a 3.0x Larger sensor area than Sigma SD9. Larger sensors give photographer more control on the depth of field and blurry background compared to smaller sensor when shot in same focal length and aperture.