SQLFluff Linter (Ultimate Edition)
JetBrainsAnbora-labs · v—
Provides support for the SQLfluff linter. Note: Please make sure to install sqlfluff; pip install sqlfluff Features: SQLfluff linter integration Quick fixes for simple linter rules Right click -> Run 'sqlfluff fix'
Rating distribution
Reviews 8
Works great, I'm using it with dbt -- but by default it checks for profiles.yml in the home directory, which sqlfluff doesn't do, it uses where the profiles.yml is. So in .sqlfluff, if your profiles.yml is in the root dir: [sqlfluff:templater:dbt] profiles_dir = ./
newest version works very well with dbt. Love it.
So far so good. Doco/Getting started could be made more clear. I noticed that it IS available by right-clicking on file (as noted in "Getting started) and seeing the menu item Run sqlfluff I also noticed that it is important to keep your pyenv env global/local in sync with whatever is captured against global/manual in pylint settings - this part you might want to make a little more clear...
I was having a difficult time getting this running until I realized that in settings, where it says "Config .sqlfluff path" - the file picker lets you select a directory, not a file. But for me it only worked once I manually added ".sqlfluff" at the end of my path. After that it seemed to work correctly for me, but I spent way too much time troubleshooting that!
And 1 star for a plugin which doesn't work
It doesn't work for me also
its frustrating that this does not work
It doesn't work. I see sqlfluff [ST06]: Select wildcards then simple targets before calculations and aggregates. sqlfluff [LT02]: Expected indent of 4 spaces. ... But I don't need this warnings and messages! I need to get reformatted code! And it hasn't a "right click" options. So... this plugin is completely useless. It's not such a pity as I payed only 1 $
Similar in “Database”
Database Navigator
oracle
Database Tools and SQL for WebStorm
JetBrains
XLS Loader
JetBrains
Redis
bruce-ge
DynamoDB
Anton_Shuvaev
Elasticsearch
Anton_Shuvaev