How can we help you today? How can we help you today?

Getting SQLFluff to work w/ Community Version?

I am using the Community version of Flyway CLI, 12.4.0.

I am trying to run a “flyway check” in a Github Action as part of a CI/CD process. I am using the “red-gate/setup-flyway@v3.3.1” github action to configure the CLI.

I'm installing sqlfluff via a “pip install” command after using the “actions/setup-python” action. (I have tried both 3.4.0 and the latest, which is 4.1.0.)

‘which sqlfluff’ reports a path to the executable, and ‘sqlfluff --version’ reports its version correctly.

I have tried with the environment variable “FLYWAY_ENV_NATIVE_SQLFLUFF” set to both false and true.

Regardless, during the check process, I get the following output:

{"level":"INFO","message":"SqlFluff version null"}

{"level":"INFO","message":"SQLFluff code analysis summary: operation skipped as no migration SQL files detected"}

I read that the “null” is due to flyway not being able to find the executable? But I've read through the documentation and can't find any way mentioned to tell flyway explicitly where the sqlfluff executable is.

Thanks for any advice. :-)

Dave P.
0

Add comment

Please sign in to leave a comment.