How bad is my first colonoscopy gonna be?

About to drink the magical prep juice. How rough is this whole thing gonna be?