I’m implementing the SQL linter/formatter SQLFluff as part of our CI process. Part of the setup is choosing the SQL dialect for the linting and formatting, which unfortunately at time of writing does not include Dremio. ANSI SQL was the first dialect i tried, but this misses some functions such as ROW_NUMBER since this seems to be outside ANSI specifications. I then chose the BigQuery dialect since there is some relation to Dremel, as Dremio has as well. This does seem better, ROW_NUMBER is picked up. Still, I’m not convinced this is the best choice.
I’m therefore asking if anybody has implemented SQLFluff and what you chose as the dialect? This is the current list of dialect supported by SQLFluff: Dialects Reference — SQLFluff stable_version documentation
@azur.rosenlov Were you able to conclude which sqlfluff parser is most compatible with dremio or it is not consistent, thanks