SQL notebook

The SQL notebook is an interactive environment for performing queries on all SQL databases supported by Dataiku.

It supports all kinds of SQL statements, from simplest SQL queries to advanced DDL, stored procedures, …

A SQL notebook is attached to a single SQL connection of Dataiku.

Creating a SQL notebook

You can create a SQL notebook either from the “Notebooks” tab of your project. Select SQL and then select the SQL connection on which you want to create the notebook.

Cells and history

A SQL notebook is made of several cells. Each cell is where you execute and modify a single query and view its results. The recommended way to work with a SQL notebook is to keep a single cell for each query that you might want to rerun at a later time.

Each cell has its own history so you can work on tuning and debugging your queries with confidence, you’ll always be able to find previously executed states.

Table View

The table view offers the same interactive exploration capabilities found in standard Dataiku datasets. You can use it to view and analyze the first 1000 rows of the results of your query.

You can perform column analysis to view statistics, search for specific values, and apply filters or sorts to the results without needing to re-run the query. Additionally, you can customize the display by hiding or showing specific columns to focus your analysis.

Chart

You can visualize the first 1000 rows of your query results using the Dataiku charting engine.

Just as with standard datasets, you can create multiple charts based on the output of your query. You can create, edit, and delete as many charts as needed to analyze your results visually.

AI SQL Generation

Dataiku includes an AI Assistant to help users write SQL queries. Please see SQL Assistant