ODC allows you to customize the SQL development interface and some team collaboration features.
Procedure
Log in to the ODC console. In the lower-left corner of the page, click Settings to go to the user settings page. Configure the settings for individual users and team workspaces as needed.
User settings
| Type | Parameter | Description |
|---|---|---|
| Session | MySQL Commit Mode | Specifies the default transaction commit mode in MySQL compatible mode. |
| Session | Oracle Commit Mode | Specifies the default transaction commit mode in Oracle compatible mode. |
| Result Set | Obtain Result Set Column Information | Specifies whether to retrieve column information when executing SQL statements. If you disable this option, the system does not query column comments and editable column information when there are a large number of table columns, thereby reducing the SQL execution time. |
| Result Set | Obtain Row ID | Specifies whether to retrieve Row ID. |
| SQL Execution | Enable End-to-end Trace Diagnostics | Specifies whether to enable end-to-end tracing when executing SQL statements. |
| SQL Execution | Continue Execution on Error | Specifies whether to continue executing SQL statements when an error occurs. |
| SQL Execution | Delimiter | Specifies the delimiter for SQL statements. |
| Object | Type of Statement Generated Using Object Drag-and-Drop | Specifies the type of SQL statements automatically generated by dragging database objects (such as tables and views) to the editing area. |
| Style | Theme | Specifies the theme of the editor, including OceanBase, VSCode, and GitHub. |
| Style | Font Size | Specifies the font size of the editor, which can be small, normal, or large. |
| Shortcut | Run SQL | Specifies the shortcut key to run all current SQL statements. |
| Shortcut | Run Selected SQL | Specifies the shortcut key to run the selected SQL statements. |
| Theme | - | Specifies the page theme color. |
| Workspace | Default Workspace | Specifies whether to display the team workspace or individual workspace after the login account is created. |
| Privacy | User Behavior Analysis | Specifies whether to enable user behavior analysis. |
Team workspace settings
| Type | Parameter | Description |
|---|---|---|
| SQL Query | Maximum Entries per Query | The default upper limit is dynamically configured based on the query result limit in the MetaDB. You can decrease the upper limit as needed. |
| SQL Query | Default Entries per Query | The default value is 1000, which cannot exceed the upper limit configured for the query result limit. If the upper limit is less than 1000, the default value is the upper limit. |
| Ticket Task | Allow Schema Substitution for Import Tickets | If the target database already contains a table or object with the same name, this configuration allows you to directly replace the existing schema (such as tables and views) during data or database schema import. |
| Ticket Task | Automatically Generate Backup Rollback Plan for Database Changes | Specifies whether to automatically generate a backup and rollback plan when database changes are made. |
| Ticket Task | Query Results of Database Changes | Specifies whether to allow you to view and download query results in database change tickets. |
| Ticket Task | Default Execution Mode of Database Changes | Specifies the default execution method when creating a database change ticket. |
| Ticket Task | Task Description Prompt | When submitting a ticket, you can use predefined prompt text to guide you in filling out the task description. The description must be within 200 characters. |
| Security | Data Source Access Key | Specifies the access key for the data source. |