Customize the Data Notebook workspace

As a Data Notebook administrator, you can customize the following workspace settings, which apply to all notebooks and for all users.

Setting	Description
Default Color Palette for Charts	Color palette for charts. A default color palette is automatically applied to all the charts generated in notebooks. 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	Numbers in query results. By default, the numbers in query results in notebooks 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.
Query-only statements	Running of query-only statements. By default, users can run any type of SQL statements in notebooks, 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	Download of query results. By default, users can download query result tables in notebooks 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.
Enforce Data Retention for Query Results	Retention of query results. 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 how long should query results 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 the query to generate the 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.

Prerequisites

You have a global role that has the following global permissions:

Product Rights > Data Notebook
Data Notebook > Manage settings

Steps

Open the Workspace page.
More information
1. On the main toolbar, click , and then click Data Notebook.
  The Data Notebook homepage opens.
2. In the left pane, click Settings.
  The Workspace page opens.

Customize the workspace settings as needed.

Tip To change the default color palette, select the color set, and then enter the following information in the Edit color palette dialog box.

Field	Description
Name	A name to identify the color.
Value	The hexadecimal code of the color you want. Clicking the color itself opens a color palette for finer adjustments.
Apply automatically to columns	Names of the columns to which you want the color to be applied when the columns are shown in charts. To separate the columns, use a comma. Example STARTER, number_of_users

Field

Description

Name

A name to identify the color.

Value

The hexadecimal code of the color you want.

Clicking the color itself opens a color palette for finer adjustments.

Apply automatically to columns

Names of the columns to which you want the color to be applied when the columns are shown in charts.

To separate the columns, use a comma.

Example STARTER, number_of_users

Your changes are saved and applied to all notebooks for all users.