Search code examples
formattingsqlfluff

What is the difference between the 'fix' and the 'format' commands in SQLFluff?

It's not clear to me what is the difference between these two commands available in SQLFluff:

fix       Fix SQL files.
format    Autoformat SQL files.

What is the difference between the two commands?

Solution

  • From the docs:

    format

    Autoformat SQL files.

    This effectively force applies sqlfluff fix with a known subset of fairly stable rules. Enabled rules are ignored, but rule exclusions (via CLI) or config are still respected.

    So we see format is a reduced/simplified or less-aggressive version of fix. Though it's also possible the "effectively" weasel word here carries a lot of water.