Is there any linter for vsql scripts?
We would like to extend our CI/CD pipeline with running validation/linting of sql scripts during the authoring process. We found no good solution for this yet.
What I did so far
While DataGrip from JetBrains has support for the Vertica dialect, that is an IDE not a solution for CI/CD.
Contacted Vertica Support, they suggested to ask this question here.
I did a bit of googling, and found a curated list of linters, but no turn key solutions for vertica:
- SqlFluff seems to be a great option, but it does not have a Vertica dialect yet.
- sql-lint might be another option, but not mature yet, also aims to be generic, not considering dialects.
What we need
An open source solution would be better, but a subscription based/proprietary one would also be great.
I'm kinda surprised that there is no official Vertica solution for this.
Any suggestions? Thanks!