Personal databases and private notebooks¶

Attention

This behavior change is in the 2025_01 bundle.

For the current status of the bundle, refer to Bundle History.

When a user creates a private notebook, a personal database and a schema named PUBLIC are created for the user. The personal database acts as a dedicated workspace for creating, modifying, and managing private notebooks, which are accessible only to the individual user.

You can use the following SHOW and DESCRIBE commands to view information about private notebooks, personal databases, and schemas inside those personal databases:

DESCRIBE NOTEBOOK
SHOW DATABASES
SHOW SCHEMAS
SHOW NOTEBOOKS

Before the change:: When a user creates a notebook, it is owned by the user’s current role and viewable by any user with that role.
After the change:: By default, notebooks are private and owned by the current user. When a private notebook is ready for production, a user can deploy it to a standard, non-personal database.

For details, see Private notebooks.

Ref: 1872