You asked

Is the sigma 15mm f 1 4 dg dn diagonal fisheye art good in low light?

Here is what the site says about that.

From Sigma 15mm f/1.4 DG DN Diagonal Fisheye Art: Sigma 15mm f/1.4 DG DN Diagonal Fisheye Art: A prime lens by Sigma for Full frame cameras, 15mm f/1.4. A fast full-frame fisheye, made with night-sky photography in mind. Specs - Maker: Sigma - Focal length: 15mm (prime) - Maximum aperture: f/1.4 - Made for: Full frame sensors - Mounts: Sony E, L-Mount - Stabilised: no - Autofocus: yes What it frames like - On full frame (Sony E, L-Mount): as marked, 15mm. - On APS-C (Sony E, ...

From Sensor sizes: Is full frame worth it?: For low light, events, and portraits with very shallow depth of field, yes. For travel, street, wildlife on a budget, and most hobby photography, a good APS-C camera with good lenses is enough, and you'll carry it more. Lenses and light matter more than the last stop of sensor performance.

Quoted from this site's pages.

From these pages