This section provides a brief overview of Xcalar Notebook.
This guide is intended for analysts, data engineers, data scientists, and data application developers, who are responsible for identifying, writing, developing, and operationalizing distributed data processing applications.
To use this document, you need a basic familiarity with SQL.
Understanding Xcalar Notebook
Xcalar Notebook is a browser based visual design studio for designing and creating functions and data applications.
The Xcalar Notebook integrated development environment (IDE) workspace contains two main data application development areas:
- SQL panel
This panel provides a SQL editor for you to create, edit, and run your SQL statements. It enables you to create data applications by applying SQL statements using Xcalar SQL on your source data from the tables that you created in Xcalar Load. The SQL panel also provides links to features for analyzing your statements, viewing your resultant data details, and creating advanced function extensions from Python and SQL that expand the Xcalar SQL syntax. For more information, see Working with Xcalar SQL.
- App Builder
This panel augments the SQL panel by providing features and functions for monitoring and troubleshooting your statements and applying Xcalar built-in operators. For more information, see Developing your applications.
Other panels and features, as shown in the following screenshot, include:
- Resources panel, which is divided into sections that expand to display and manage your Xcalar Notebook resources:
- SQL Statements
- Table Functions
- Scalar Function
- Table panel, which enables you to visually see and analyze your source and resultant data in tabular format as tables and intermediate tables. It also contains features and functions that enable you to perform data manipulation and debugging actions on the columns, fields, and records of your tables. For more information, see Understanding the Table panel.
- Table Details panel (not shown), which enables you view information about your tables, including creation time, row count, size, and the table’s state as either Resident or Non-Resident. For more information, see Understanding the Table Details panel.
- SQL History tab, which enables you to monitor and track the development history and SQL details. For more information, see Understanding the SQL History tab.