Login Sign up

Monday Oct. 12, 2020, 4:45 p.m.–Oct. 12, 2020, 5:15 p.m. in Jupyter Community: Practices

Supercharging SQL Users with Jupyter Notebooks

Michelle Ufford

Audience level:
Novice

Brief Summary

In this talk, we’ll describe how Jupyter notebooks can be leveraged to significantly uplevel the data experience for SQL users. We’ll do this by introducing a 3-tier action plan that describes how companies such as Netflix have successfully created a well-integrated SQL experience within Jupyter. Users will walk away with a practical plan & helpful resources to implement in their own environments.

Outline

In this talk, we’ll share a practical action plan for how Jupyter notebooks can significantly uplevel the data experience for your SQL users. We’ll do this by introducing a three-tier action plan that describes how companies such as Netflix have successfully created a well-integrated SQL experience within Jupyter.

This action plan will cover how to: - build a strong foundation that makes SQL more accessible for your users - increase productivity with a secure & integrated user experience; and - customize & extend SQL support to meet the unique needs of your organization.

We’ll first look at why notebooks are so appealing for SQL users and explore some of the traditional challenges they often face when working with notebooks. We’ll describe how JupyterHub can be leveraged as a solid foundation and the advantages of doing so. We’ll then describe how adding SQL magics & popular libraries to your JupyterHub environment can lead to a dramatically better experience for your users, and we'll offer some suggestions to get you started.

Next, we’ll discuss how a secure & tightly integrated environment can lead to increased productivity for your users. We’ll explore how some easy configuration changes can have an enormous impact on your user experience. We’ll also offer some ideas for integrating Jupyter into the rest of your data platform and discuss the advantages of using notebooks in your automated workflows.

We’ll then move onto customizing and extending Notebooks using custom data magics and custom extensions. We’ll conclude with some ideas for customizing your Jupyter environment to meet the unique needs of your organization.

Attendees will walk away from this session with best practices, tips and suggestions, links to useful resources, and an actionable plan they can implement in their own organizations.