You, as drone operator, are always required to have an insurance for your drone if you are using a drone with a weight above 20kg. However most of EASA Member States mandate a third party insurance also if you are operating a lighter drone. So please consult the national regulation.
Regulatory reference: Article 14 (2) (d) of EU regulation 2019/947.