Notebook settings

As an administrator, you can manage settings for SQL statements, query results, chart color palettes, number formats in query results, and access requests to Data Notebook.

The following table describes the settings for Data Notebook. These settings can be accessed via Data Notebook homepage → Settings or via Collibra settingsData Notebook.

Setting Required global permission Description
Data sources
Data sources Data Notebook > Manage data sources

Allows registering data sources for Data Notebook and removing the registered data sources.

You can register a data source via Register data source. For more information, go to Register a data source for Data Notebook.

The Connected section shows a list of registered data sources. You can remove a registered data source by clicking Remove data source. Users will then no longer be able to run queries against that data source.

Queries governance
Enforce data retention for query results Data Notebook > Manage settings

Determines whether data retention of query results in notebooks is enforced.

By default, when a notebook is permanently deleted, any query results associated with the notebook are also automatically deleted from the database. You can specify the duration for which the query results should be kept in the database. Once the retention period has passed for a set of query results, it is automatically deleted from the database. Users can still re-run a query to generate results.

For example, if you set the retention period to 1 year, the results of a query run in a notebook will be deleted from the database after 1 year, even if the notebook still exists.

Query-only statements Data Notebook > Manage settings

Determines which type of SQL statements can be run in notebooks.

By default, users can run any type of SQL statements, including both read and write operations. You can allow only query statements such as SELECT to be run, to prevent users from running other types of statements, such as the following: ADD, ALTER, CREATE, DELETE, DROP, EXEC, GRANT, INSERT, TRUNCATE, UPDATE.

Allow download of result sets from data notebook user interface Data Notebook > Manage settings

Determines whether query results in notebooks can be downloaded.

By default, users can download query result tables by hovering over the tables and then clicking Download results. You can hide this button to prevent the download of query results from all notebooks. Users can still download query result charts.

Number and colors
Default color palette for charts Data Notebook > Manage settings

Determines the color palette for charts in notebooks.

A default color palette is automatically applied to all the charts. You can change this default palette to suit your preferences.

Tip  You can also override the default color palette by selecting specific colors for each chart directly within a notebook. For more information, go to Customize the notebook chart.
Number formatting Data Notebook > Manage settings

Determines the format of numbers in query results in notebooks.

By default, the numbers in query results are formatted according to the web browser settings of the user who is viewing the results. For example, if a user's browser is set to US English, the numbers are formatted according to the US English conventions. You can change the default number formatting to use a decimal point or a decimal comma. This ensures that numbers are formatted according to the locale you select, regardless of the individual browser settings.

Access requests (beta)
Access requests Data Notebook > Manage settings

Determines whether users can request access to Data Notebook.

By default, this setting is disabled and users can't request access. If you enable the setting, you can allow users of specific groups to request access. The Data Notebook option then appears for such users when they click Products icon on the main tollbar, but the option directs them to a request access form rather than the application, until their request is approved. For more information, go to Request Data Notebook access (beta).

Users with request access Data Notebook > Manage settings

Determines who can request access to Data Notebook. This setting allows you to activate the feature for only a selection of groups, allowing for targeted deployment.

By default, all users can request access if the Access requests setting is enabled. You can limit access requests to specific user groups. If no groups are selected, all users can request access.

Users who can approve requests Data Notebook > Manage settings

Determines who can review access requests for Data Notebook and approve or reject them.

By default, review requests are sent to users who have the System administration global permission. You can select specific users and groups to review access requests. If no users or groups are selected, only system administrators can review access requests.

Group and role assignment Data Notebook > Manage settings

Determines which groups or roles can reviewers assign to users during approval.

By default, all global roles can be assigned to users. You can select specific global roles or groups for assignment during approval. Your selected roles or groups become available for reviewers to assign to users when approving their access requests. If you don't select any roles or groups, reviewers can assign any roles or groups to requesters.