whale icon indicating copy to clipboard operation
whale copied to clipboard

Add SSH tunneling capabilities.

Open rsyi opened this issue 4 years ago • 0 comments

Currently, it's a bit difficult to set up metaframe in some companies where you have to ssh into a devbox to run your queries. It's possible, however, to get around this by using paramiko to set up an SSH client to execute your query in your devbox, pipe the results to a csv, then scp the results back to localhost.

To enable this, we can add an ssh argument to our extractors to enable this pattern, using a gateway machine. I'm not entirely sure how this works for every sort of database, but I know for presto this looks something like client.execute('presto --execute {}'.format(query).

rsyi avatar Jun 18 '20 04:06 rsyi