DataSpell 2024.1 EAP 2 Is Out, Focusing on dbt Core
The second Early Access Program (EAP) release of DataSpell 2024.1 delivers a range of exciting updates focusing on enhanced dbt Core support. This EAP version enhances code completion, introduces the ability to incorporate environment variables into run configurations, and enables the execution of models directly from SQL files.
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 2024.1 EAP 2. Please try them out and share your feedback in the comments below or in our issue tracker.
dbt Core code completion
The recent upgrade has improved code completion functionality. DataSpell now offers smart suggestions for column names directly from the code in your models, even before these models are materialized in a database. To get a better understanding of what this enhancement means, check out the video:
Run, test, or preview models from an SQL file
We’ve introduced a much-anticipated feature that allows you to run, test, or preview the compiled code of a model directly from an SQL file. This new functionality includes a convenient gutter tool, enabling you to execute your models without needing to input commands in the terminal.
Add environment variables to the run configurations
Now you can add environment variables such as user name or password into dbt run configurations. This functionality is essential for securing sensitive information, enabling flexible configuration management, and supporting scalable collaboration without embedding credentials or environment-specific details in the codebase.
These are the most important updates for DataSpell 2024.1 EAP 2!
We’re excited to hear what you think!
Subscribe to Blog updates
Join the Livestream: How to work with SQL and Databases in DataSpell
We invite you to join our livestream How to work with SQL and Databases in DataSpell. The event will take place on Monday, January 22, at 1:00 PM UTC. Date: January 22, 2024 Time: 1:00 pm UTC (2:00 pm CET / 8:00 am EST) Register In this livestream, we’ll show you how to write…
DataSpell 2023.3: AI Assistant, dbt Core Support, SQL Cells, Interactive Table Productivity Boosters
DataSpell 2023.3 introduces features designed to help you significantly boost your productivity. JetBrains AI Assistant is now generally available with a number of new and improved features. We've integrated support for dbt Core, the well-known data transformation framework, into DataSpell. Working…
DataSpell 2023.3 EAP 4 Is Out! AI Assistant, SQL Cells, and Improvements for Interactive Tables
The fourth EAP build for DataSpell 2023.3 brings completion for database objects in SQL cells, the ability to get insights from your DataFrame using JetBrains AI Assistant, productivity boosters for interactive tables, and Full Line Code Completion. To catch up on all of the new features in DataS…
DataSpell 2023.3 EAP 3 is out! Introducing dbt® support!
The third EAP build for DataSpell 2023.3 brings dbt® support, JetBrains AI Assistant actions via the context menu in Jupyter, and easy access to column statistics and data distribution histograms in tables. To catch up on all of the new features in DataSpell 2023.3, check out our previous EAP blo…