I have had at least 3 done. Once under full anesthesia, twice under moderate sedation. here is an article that has more information - Endoscopy Sedation | GastroNet

If you have any concerns be sure to talk to your doctor beforehand.

The only discomfort was momentary during the insertion of the needle for the IV and maybe slight discomfort of the throat afterwards. Like others have posted, I was out before they inserted the tube so did not feel that at all and the next thing I was awake. Only remember once singing at the top of my lungs whilst drifting off to sedation

I always tried to get a morning appointment so doc would not be too tired.

I hope all will go well for you!