From 7 July onwards you can visit Dubai as a normal tourist.
In addition to the usual visa regulations (for citizens of Schengen countries there is free visa on arrival), all that is required is a current health certificate on COVID-19 or an on-site-test at the airport.
Download the Dubai Travel Guidelines by Dubai Media Office as PDF (21 June 2020).
