Code Completion

Only type-based completion

By default, DataSpell suggests completion for symbols regardless of their types. With this approach, in complicated cases the list shows multiple completion variants.

To make completion more precise, select the checkbox. The completion list will strongly depend on the DataSpell inference. As a result, the list may remain empty in case of poor inference.

Suggest items with optional chaining for nullable types

By default, DataSpell suggests completion for symbols with the optional chaining operator (?). To suppress showing such suggestions, clear the checkbox.

Expand method bodies in completion for overrides

By default, when you want to override a method from the parent class or interface and select this method from the list of completion suggestions, DataSpell automatically adds parameters, generates a super() call, and adds the type information, if possible.

Clear the Expand method bodies in completion for overrides checkbox to suppress automatic generation of method bodies for overrides during completion.

Completion of names

• Suggest variable and parameter names: By default, the checkbox is cleared. When it is selected, DataSpell suggests names for new class fields, variables, and parameters during their declaration. These suggestions are based on the names of classes, types, and interfaces that are defined in your project, in the libraries you are using, and in standard APIs.

• Suggest names for class fields

  The option is by default turned off.

• Add type annotations for suggested parameter names: Select this checkbox to supply each completion suggestion with information on its type.

  The checkbox is available only when the Suggest variable and parameter names checkbox is selected.

Show parameter name hints on completion

Select if you want hints for parameter values to be displayed.

Show the parameter info popup in

Select this checkbox to have DataSpell automatically show a popup with all available method signatures when an opening bracket is typed in the editor, or a method is selected from the suggestion list.

In the text field to the right, specify the delay (in milliseconds) after when the popup window should appear.

If this checkbox is not selected, use Ctrl+P to show parameter info.

Show full method signatures

If this checkbox is selected, the parameter info displays full signatures, including method name and returned type.

Suggest objects from

Select where the objects are suggested from:

• The current search path only: only the schema selected for a console.

  For more information about selecting a schema, refer to Select the default schema.

• The current scope: the schema currently selected for a console and system schemas (for example, pg_catalog in PostgreSQL.

• All available schemas: all introspected schemas.

Qualify objects with

Select when to qualify the objects with databases, schemas, tables and views, and aliases of tables and views.

Qualify objects in

Select when to qualify the objects in the given cases.

JOIN clauses

Use aliases in completion for JOIN

Creates aliases for tables in the JOIN statement.

Invert order of operands in auto-generated ON clause

Switches operands in the ON clause. When the checkbox is cleared, the FROM table comes the first in the JOIN condition.

Suggest non-strict foreign keys based on the name matching

Generates you a list of possible code completion suggestions for JOIN statements. The code completion list includes suggestions of the columns from other tables that have the same names as columns from the table in the JOIN statement.

Read more about debugging rules for this option in Debug rules for virtual foreign keys.

Table aliases

Automatically add aliases when completing table names

Creates an alias for a table name.

Suggest alias names in completion after table names

Suggests an alias for a table name when you use code completion (Ctrl+Space).

Custom aliases (table)

You can add a table name and the alias that you want to use for this table. To add the table-alias pair, click the Add alias button ().