Updated on 2025-12-10 GMT+08:00

Data Development Settings

Procedure

  1. Log in to the DWS console.
  2. In the navigation tree, choose Data > SQL Editor.
  3. Click Configure in the upper right corner and set parameters as required.

    Table 1 Setting parameters

    Settings

    Description

    Editor

    Provides basic settings for compiling SQL statements in the editor. For example, if Autocomplete is selected by default, some keywords can be automatically filled. If you select Autocomplete Table/Column Name, table or column names can be automatically filled when a table is complied.

    Shortcuts

    You can use shortcut keys to quickly compile SQL statements in the editor.

    User Settings

    You can also activate database and schema permission filtering, which limits the create permission of the database and the usage permission of the schema to the current database user. You can enable the function of displaying comments on table column names. After the function is enabled, run the select * from [Table name] command. The table header in the returned result contains the comments of the column.

  4. Confirm the information and click OK.