Add sqlfluff support to cloud cli doc

[mirnawong1]

Contributions

• I have read the contribution docs, and understand what's expected of me.

Link to the page on docs.getdbt.com requiring updates

The dbt Cloud CLI now supports sqlfluff and we should add this to the docs for users so they don't install the templater and so we avoid user confusion.

This was raised by Tania in the internal slack: https://dbt-labs.slack.com/archives/C06FWKP5V28/p1719903106508059

Things to add:

• when you run dbt sqlfluff, it picks up changes to the user's local .sqlfluff config
  • how?
• SQLFluff is available in the latest release of Cloud CLI (0.38.4).
• To get started, run dbt sqlfluff -h to see the list of supported commands and flags
• sqlfluff commands in the cloud cli do not return exit codes yet
• Use sqlfluff commands in github actions using the Cloud CLI (slack thread
• To use sqlfluff in CICD, a dbt_cloud.yml a file will need to exist with the correct config and commands will need to be run from a valid dbt project.

Available sqlfluff flags/commands in cloud cli:

➜  jaffle-shop git:(mwong-test-cli) ✗ dbt sqlfluff -h
SQLFluff is a modular SQL linter for humans.

Usage:
  dbt sqlfluff [command]

Available Commands:
  fix         Fix SQL files.
  format      Autoformat SQL files.
  lint        Lint SQL files via passing a list of files or using stdin.

Flags:
  -h, --help   help for sqlfluff

Global Flags:
      --log-format LogFormat   The log format, either json or plain. (default plain)
      --log-level LogLevel     The log level, one of debug, info, warning, error or fatal. (default info)
      --no-color               Disables colorization of the output.
  -q, --quiet                  Suppress all non-error logging to stdout.

Use "dbt sqlfluff [command] --help" for more information about a command.

What part(s) of the page would you like to see updated?

Proposed place: https://docs.getdbt.com/docs/cloud/configure-cloud-cli#use-the-dbt-cloud-cli

Additional information

PRD for linting from the dbt Cloud CLI