I needed to set the extension's path in setting.json:
"sqlfluff.env.environmentVariables": [ { "key": "PATH", "value": "/Users/nir/venvs/python/bin/" } ]