Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add SSH tunneling capabilities. #23

Open
rsyi opened this issue Jun 18, 2020 · 0 comments
Open

Add SSH tunneling capabilities. #23

rsyi opened this issue Jun 18, 2020 · 0 comments
Labels
enhancement New feature or request

Comments

@rsyi
Copy link
Owner

rsyi commented Jun 18, 2020

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 rsyi added the enhancement New feature or request label Jun 18, 2020
@rsyi rsyi added this to To Do in v0.0.0 via automation Jun 18, 2020
@rsyi rsyi removed this from To Do in v0.0.0 Oct 14, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant