Notebook settings

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

You can register a data source via Register data source.

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.

Determines if 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.

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.

Determines if 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.

Determines if the number of query results are limited to the first 100 rows when a query is run.

By default, users can modify the row limit for a notebook using the Apply 100-row limit option in the notebook. They can also modify the row limit for individual queries in a notebook using the 100-row limit on this query option in query blocks.

Determines if 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 on the main toolbar, 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 (in preview).

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.

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.

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.

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.

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.

Determines which resource roles are assigned to users for the Data Notebook assets created when they publish notebooks.

If the selected roles don't collectively include any one of the following resource permissions, a warning appears:

• Asset > Data > View notebook content
• Asset > Update
• Asset > Remove

By default, the Owner and Data Analyst Level 2 resource roles are assigned. You can always revert to these original default roles by clicking Reset to default when configuring the setting.