Local Preferences
Overview
Team Edition provides extensive customization and management capabilities through its Preferences settings, 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 |
|---|---|---|
| Language | Sets the application's language. | No |
| Available languages: | ||
| - English | ||
| - French | ||
| - German | ||
| - Italian | ||
| - Japanese | ||
| - Korean | ||
| - Brazilian Portuguese | ||
| - Romanian | ||
| - Russian | ||
| - Simplified Chinese | ||
| - Spanish | ||
| - Traditional Chinese | ||
| - Ukrainian | ||
| Theme | Application color theme. Available themes: | No |
| -Light | ||
| -Dark |
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 |
|---|---|---|
| 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 |
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 |
Logger
| Setting | Description | Admin only |
|---|---|---|
| Enable detailed logging | Enables detailed logging of GraphQL queries in the server log, including all variables. | 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 |
Read more about ERD viewer
Query Manager
| Setting | Description | Admin only |
|---|---|---|
| Automatic history cleanup | Automatically deletes old query history once a day. If turned off, history is kept forever. | Yes |
| Days to store history | Number of days to keep query history. Older records are deleted daily. | Yes |
Read more about Query Manager.