Local Preferences
Overview
Team Edition provides extensive customization and management capabilities through its Settings page, allowing both administrators and regular users to tailor the application according to their needs. To access these settings:
- Administrators: Navigate to Settings -> Administration -> Global Preferences.
- Users:
- Go to Settings -> Preferences.
- Alternatively, navigate to Profile -> Preferences
Preferences
Upon accessing the preference page, you will encounter the following settings for customization:
Interface
| Setting | Description | Admin only | Variable values |
|---|---|---|---|
| Language | Sets the application's language. | No | |
| Available languages: | |||
| - English | en |
||
| - Arabic | ar |
||
| - French | fr |
||
| - German | de |
||
| - Italian | it |
||
| - Japanese | jp |
||
| - Korean | ko |
||
| - Portuguese (BR) | pt_BR |
||
| - Romanian | ro |
||
| - Russian | ru |
||
| - Simplified Chinese | zh |
||
| - Spanish | es |
||
| - Traditional Chinese | tw |
||
| - Ukrainian | uk |
||
| - Vietnamese | vi |
||
| Theme | Application color theme. Available themes: | No | |
| - Light | light |
||
| - Dark | dark |
Tip
Variables are part of Product settings parameters. For more details, see Product settings parameters.
Data viewer
| Setting | Description | Admin only |
|---|---|---|
| Disable Import | Disables importing of data in Data Viewer for non-admin users. | Yes |
| Disable Table presentation | Disables the table view in Data Viewer. | Yes |
| Disable Copy | Disables copying of data in Data Viewer. | Yes |
| Disable Export | Disables exporting of data in Data Viewer for non-admin users. | Yes |
| Disable Edit | Disables editing of data in Data Viewer. | Yes |
| Default fetch size | Default number of rows to fetch. | No |
| Maximum fetch size | Maximum number of rows to fetch. | Yes |
SQL Editor
| Setting | Description | Admin only |
|---|---|---|
| Autosave script files | Automatically save the script files. | No |
| Import limit (KB) | Sets the maximum file size that can be imported (in KB). |
No |
| Insert table aliases | Automatically inserts table aliases in the FROM clause of a SQL query. Options: |
No |
| - Disable: Do not insert any aliases automatically. | ||
| - my_table mt: Use a short alias for tables. | ||
| - my_table AS mt: Use the AS keyword with a short alias for tables. | ||
| Use long object names | Always use schema/catalog for object names. | No |
Info
Read more about SQL Editor.
Tools
| Setting | Description | Admin only |
|---|---|---|
| Disable log viewer | Disables the ability to view logs for all users. | Yes |
| Disable Tools | Removes Tools menu from the top menu bar. | Yes |
Diagram
| Setting | Description | Admin only |
|---|---|---|
| Max elements to display | Sets the maximum number of elements (tables, columns, etc.) shown in the ERD viewer. | No |
Info
Read more about ERD viewer
Administration
Query Manager
| Setting | Description | Admin only |
|---|---|---|
| Automatic history cleanup | Automatically deletes old query history once a day. If turned off, history is kept forever. Cleanup removes entire log files based on their last modification date, not individual records. A new log file is created on each server restart. Only complete files are deleted - partial cleanup inside files isn’t supported. | Yes |
| Days to store history | Number of days to keep query history. Files older than the set number of days (based on last modification date) are deleted daily. | Yes |
| Number of days to retain record files | Deletes record files once per day if they were last modified earlier than the specified number of days. | Yes |
| Save records to a file | Saves query manager records to a file in the metadata folder (/opt/workspace/.metadata). Customize the path using a .env variable. Read more about environment file configuration. |
Yes |
Info
Read more about Query Manager.
Logger
| Setting | Description | Admin only | Additional articles |
|---|---|---|---|
| Enable detailed logging | Enables detailed logging of GraphQL queries in the server log, including all variables. | Yes | - Log customization - Log viewer configuration |
Navigation tree
| Setting | Description | Admin only |
|---|---|---|
| Amount of nodes to load | Loads this number of child items in the database navigator, scripts, and datasets. Default is 100, maximum is 1000. |
No |