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 settings → Data 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 |
||||||||
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.
How to change the default color palette?
To change the default color palette, select the color set, and then enter the following information in the Edit color palette dialog box.
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 |
||||||||
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. |