robertostermann / vscode-sqlfluff-extended Goto Github PK

Hi, I've been running into a similar issue as this issue on the other vscode-sqlfluff repository. When I set

[sqlfluff]
dialect = snowflake
templater = dbt

inside of my .sqlfluff file I am unable to get the extension to properly lint my files, but when I either leave templater argument blank or set it to Jinja the extension functions properly.
I'm running sqlfluff v. 1.1.0 and sqlfluff-templater-dbt v. 1.1.0 on MacOS. Happy to provide any other information that may be of use.

mojibake occurs when fixing the following file.
"sqlfluff" directly does not cause this, so I believe it has something to do with the extension.

sqlfluff command

sqlfluff fix --dialect bigquery --config .sqlfluff work/a.sql

This command does not cause mojibake. ("force" would have done the same.)

target sql file

-- 割引金額
select a from b;

after fixed

-- 割引��額
SELECT a FROM b;

.sqlfluff

[sqlfluff]
exclude_rules = L032, L016

[sqlfluff:rules:L010]
capitalisation_policy = upper

[sqlfluff:rules:L014]
extended_capitalisation_policy = lower
ignore_words = _PARTITIONTIME, _PARTITIONDATE

[sqlfluff:rules:L019]
comma_style = leading

[sqlfluff:rules:L026]
force_enable = False

[sqlfluff:rules:L057]
quoted_identifiers_policy = none

settings.json

    "sqlfluff.dialect": "bigquery",
    "sqlfluff.config": ".sqlfluff",
    "sqlfluff.linter.run": "onSave",

Reference link

https://en.wikipedia.org/wiki/Mojibake

Hi!
Thanks for doing this extension. The original was not working for me so I tried this one.
The linTER is working correctly, but the format option is removing the content of the file.
Do you know why it could be happening?

configuration file cannot be read.
Where is the default "sqllfluff.format.workingDirectory"?

I expected the root of the project, but it seems different.

error

Error loading config: Extra config '.sqlfluff' does not exist.

settings.json

    "sqlfluff.dialect": "bigquery",
    "sqlfluff.linter.run": "onSave",
    "sqlfluff.config": ".sqlfluff",

directory tree

/
├ sql
│  └ a.py <- format target file
└ .sqlfluff

temporary solution

    "sqlfluff.dialect": "bigquery",
    "sqlfluff.linter.run": "onSave",
    "sqlfluff.config": ".sqlfluff",
    "sqlfluff.format.workingDirectory": "d:/github/repository_name" <- new!