Datalore concepts

The Home page is where you organize your work and results. The page provides access to all your workspaces, your own and shared resources, and recent activities in Datalore.

This is how the Home page looks on your first visit to Datalore:

Workspace is a collection of notebooks with a variety of shared resources, such as data sources, SSH keys, or environment variables. The Home page of Datalore is where you manage your workspaces.

Datalore users can share their workspaces with other users as part of their collaboration and further development of projects that require team effort.

Notebook is the basic Datalore document where you create and combine executable code, formulas, tables, charts, and texts.

With Python being the default language, you can also choose to code in Scala, R, and Kotlin in your Datalore notebooks.

The structure of a Datalore notebook comprises different types of cells:

• Code cells are used for coding in the programming language selected for the notebook.

• Markdown cells are used to provide explanatory or descriptive texts to your code.

• Chart cells are used to build advanced charts based on DataFrames without manually writing the required code.

• SQL cells are used to query attached databases and other data sources.

• Metric cells are used to track numerical values in your code and compare them to others.

• Export to database cells are used to append DataFrames to attached database tables.

Datalore allows you to connect and work with the data from the following types of sources:

• Imported (or created) isolated files

• The majority of the relational databases. For the full list, see Supported database types.

• SQLite, DuckDB and Pandas dataframes

• Cloud storage systems: SMB/CIFS folders, Amazon S3. Google Cloud

The editor provides an easy-to-use tool, Attached data to manage your data sources in each of your notebooks.

You attach data from your connected data sources to the notebook in order to access it in the code.

To help you query attached data easily and quickly, Datalore provides a special type of cells, SQL cells.

Reports are presentations of your notebooks in form of HTML pages where you choose which parts of the notebook are visible to the viewer and how they can interact with them.

You can publish your notebooks as static or interactive reports to give the audience the opportunity to control how they view the presented data.

In many cases, a report is the final result of your work on a particular notebook and the best way to display the data your target audience is most interested in, hiding the coding part, which can be irrelevant for such demonstrations.