This is a hyperlapse with Long Exposure. You will need to use Manual Settings (Pro Settings) for this.
The video you linked, shows a static camera, which is easier because it is not drifting or moving around at all.
If you want to do this with a drone, you will need a calm day, without wind. You set the flight mode to Cine and go to Hyperlapse mode (Free), set the settings, and enable Manual Camera Settings on the bottom right. There you set manually the ISO, Aperture, and Shutter Speed. For shutter speed, I think something like 1/2 or 1/4 should be fine, but do not make it too long (not longer than a second) because then it will look blurry.
After setting shutter speed, you will need to set the ISO and Aperture, the ISO should be as low as possible, and the aperture wide open (low f-value, for example, f2.8). If with the ISO at 100 and the aperture wide open it is too bright, then close a little the aperture, if it is too dark, increase the iso to a maximum of 400, and if it is still too dark, slow down the shutter speed to 1".