SSH, Remote Files and External Table Pre-Processing
By Jean-Pierre Dijcks on Apr 12, 2011
A quick post on this as I saw the cool blog entry. The folks in development worked on this for a bit and Ferhat did the hard work of writing up his case on using the pre-processor on external tables. You can read the details here.
Make sure you look at the related PDF linked in Ferhat's post! It shows in detail how to deal with the SSH part and how it all hangs together.