Endoscopy

So I'm in need of an endoscopy and i've been having lots of stomach problems and it is time for me to do that procedure although I am very afraid I've heard that in some facilities they don't put you to sleep and that has made me get anxiety just thinking about it. Can Anyone tell me how your expierence went any tips? cause I am very scared and it was about time I get this done due to my fear of this.