Updated on 2024-10-21 GMT+08:00

Data Development Settings

Procedure

The Editor provides basic settings, including the operation bar, shortcut keys, and storage settings. If no OBS bucket is available, you can create one. For details, see Managing Buckets > Creating a Bucket in the Object Storage Service Console Operation Guide..

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

    Figure 1 Data development settings

    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

    These settings are required for OBS. You can choose to set a global OBS bucket, and any file directories you create will be saved to this bucket's folder by default. 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.

  4. Confirm the information and click OK.