snowflake-cloud-data-platform

Formatting (Indentation) of SQL Query in Snowflake SQL Editor


Do anybody knows the way or short cut keys to format any long SQL query written in Snowflake editor. I have gone through the whole Snowflake documentation, but couldn't find any.


Solution

  • In the Snowflake Web GUI, there are only some basic keyboard shortcuts (-> Documentation):
    TAB and Ctrl-[ + Ctrl-] to indent/outdent parens levels.

    Also navigation and search/replace.
    But no complete expression formatting, alas.

    We can only hope for the Numeracy acquisition to give us a fuller database web client, eventually.