3 ms·
Sorry - didn't get a chance to go through the documentation much yet... A problem we are looking to catch early in the development process is for things we don'
by nycjay 5y ago
Sorry - didn't get a chance to go through the documentation much yet... A problem we are looking to catch early in the development process is for things we don't want folks to do, even if they are technically correct. For example, dropping a column or altering the datatype/nullability in such a way that the table goes into reorg pending. I know we can write our own regex to look for that specific syntax, but I've not yet found a tool with those kinds of rules either build out already, or easy to add/maintain.
- amshank 5y agoIt's pretty new functionality in sqlfluff, but it now supports user defined plugins for org-specific rules if you want to forbid something more obscure. Documentation is sketchy, but you can see the proof of concept here: https://github.com/sqlfluff/sqlfluff/tree/main/plugins/sqlfluff-plugin-example https://github.com/sqlfluff/sqlfluff/tree/main/plugins/sqlfl...
- mixmastamyk 5y agoNice, need to forbid things like grants and setting owners that are being handled by a centralized routine.
- nycjay 5y agoThanks, I'll take a closer look there...