Check to see where the leak is first. You may have a clog in the first half segment of the pipe, or the latter. Commonly, the first half segment between the sunroof like mine due to dirt and small flowering deposits from the larger trees we parked under. Suggestion:
Retract your sunroof glass completely. While you're at it, take a bit of time to clean and grease the rail.
Take a look around the drainage holes at the top. See if there's any thing clogging them. They locate to the left and right of the rails. You can't miss them. See how much initial deposits are. It will tell you how much cleaning you may need.
Take a 24oz cup of warm water, and pour along the areas of the drainage. See if the water drains down fast or so. Fast flow means you're good. Slow and ponding means you have a nice clog somewhere. By pouring down warm water, you're creating a nice compaction and seal, readying for the next step.
Get a fuzzy stick, or firm soft stick to see if you can remove the clog at the top. Commonly, it's stuffed and crusted at the 6 inches and shallower. If there's nothing, time to take out the compressed air. Reduce the pressure down to 40psi first. High pressure will blow a nice hole along the drainage path. Seal the opening using a grommet or plastic wrap around the air spray nozzle. You may need a second person to check the drainage of the rear driverside bumper.
Test again to see if the water drains through. If not, increase air pressure to 60psi, and continue for the next 2 to 3 minutes. Test again.
Don't let the surge of air exceed 95psi. Learned it from experience.
By this time, it should be nice and clear. If not, the next thing to do is a nice 30psi to 40psi water blasting. Same method as the air compressor, but through a common water hose. Finding the attachment to reduce the hole size down can be a bit of a challenge. I got mine at the local boxstore (Lowes) for $2.