ui/ux

Table and Variable Autocompletion in Transformations

As we announced a few weeks ago, we now have a half screen mode for code blocks available. You can edit code while seeing the whole transformation. However, even with the improvement, typing table and variable names can be very tricky.

Cover Image for Table and Variable Autocompletion in Transformations

To improve code editing even more, we've just added autocompletion support to the editor.

Currently, it supports autocompletion of:

  • Language specific reserved words
  • SELECT, UPDATE, etc. in SQL transformations
  • import, while, etc. in Python transformations
  • Tables you added to Input Mapping or Output Mapping
  • When working with Python or R transformations, a relative path will be suggested (e.g., in/tables/cars.csv).
  • Variables you defined in your transformation (also with values)

To trigger autocompletion, use Ctrl+Space as you would in your favourite IDE/editor. When triggered

  • after typing ", it will suggest available tables.
  • after typing {{, it will suggest available variables.
  • in other cases, it will suggest everything (see the screenshot above).