JupyterLab SQL

[Ted Wiles]

I apologize if this has already been asked. After running my latest Navigator update, I noticed SQL notebook and kernels are now available. This could be very useful for my work. How can I connect to Redshift through the SQL workbook? 

Thanks!

Ted 

[Ted Wiles]

I realize this may be a functionality of BeakerX, which I also installed. 

[sp...@draves.org]

Hi Ted, yes BeakerX has a SQL kernel, though it is still beta.

I believe you can add RedShift drivers by copying the jar(s) into the right directory (something like $prefix/lib/python3.6/site-packages/beakerx/static/kernel/sql/lib), and then using the %defaultDatasource magic (BeakerX has dynamic loading of jars via a %classpath magic, but unfortunately the driver manager does not support custom classloaders, so that doesn't work for adding jdbc drivers, see https://github.com/twosigma/beakerx/issues/6223).

To avoid all that, we should include all the common free drivers by default. I'll see if the RedShift drivers can be included going forward.

Once it's loaded, autocomplete and interactive tables and D3 charting of results should work,
but there's a major limitation which is autotranslation from SQL to Python or Groovy is not yet supported.

Full autotranslation is something we lost going from Beaker Notebook to BeakerX and have not yet rebuilt.
Here's the issue for it: https://github.com/twosigma/beakerx/issues/5039

I would be happy to hear about your use case.

Thanks, -Scott

--
You received this message because you are subscribed to the Google Groups "Project Jupyter" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jupyter+unsubscribe@googlegroups.com.
To post to this group, send email to jup...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jupyter/b0a7e303-d20d-40b4-b40e-ca0c8fb613dd%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

BeakerX.com

ScottDraves.com

@Scott_Draves