DataSpell 2023.3 EAP 2 Is Out! Introducing SQL Cells and Graphical Representation of Column Data

Stanislav Garkusha

The second EAP release of DataSpell 2023.3 introduces several exciting features, including SQL cells in Jupyter notebooks and graphical representation of column data.

The Toolbox App is the easiest way to get the EAP builds and keep both your stable and EAP versions up to date. You can also manually download the EAP builds from our website.

Below you’ll find the most noteworthy improvements available in DataSpell 2023.3 EAP 2. Please try them out and share your feedback in the comments below or in our issue tracker.

Download DataSpell 2023.3 EAP

SQL cells

According to the 2022 State of Data Science survey by Anaconda, SQL is the second most used programming language by data scientists and data analysts after Python.

DataSpell already had great SQL support through the bundled Database Tools and SQL plugin powered by DataGrip. We’ve now gone a step further by introducing SQL cells.

Just like Python or Markdown cells, you can now use SQL cells in your Jupyter notebooks. You can get data from your database with an SQL cell, and it will be automatically put into a pandas DataFrame format to use immediately in your notebook.

To start using the cell, you need to:

• Connect a data source

• Create an SQL cell.

• Select the data source you want to use in the top-left corner of the cell. 

• Set the Python variable name where the result of the SQL request will be stored as a pandas DataFrame. 

• Start using your native SQL code and continue working in Python.

Graphical representation of column data

Visualizing data graphically is a common practice for data analysts, as it offers an easy way to understand distributions, identify potential data issues, and derive insights to guide further data exploration. To accomplish this, we’re introducing a significant simplification to your data analysis workflow – graphical representation of column data. With just a few clicks, you can build graphs based on your table data, greatly expediting the visualization process.

These are the most important updates for DataSpell 2023.3 EAP 2! 

We encourage you to try the new features and share your feedback on X (formerly Twitter) or in our issue tracker, where you can also report any bugs you find in the EAP versions. 

We’re excited to hear what you think!

Subscribe to DataSpell Blog updates

Subscribe form

By submitting this form, I agree to the JetBrains Privacy Policy Notification icon

By submitting this form, I agree that JetBrains s.r.o. ("JetBrains") may use my name, email address, and location data to send me newsletters, including commercial communications, and to process my personal data for this purpose. I agree that JetBrains may process said data using third-party services for this purpose in accordance with the JetBrains Privacy Policy. I understand that I can revoke this consent at any time in my profile. In addition, an unsubscribe link is included in each email.

Submit

Thanks, we've got you!