Not specifying a SQL Dialect in extension settings leads to confusing error

[dsmith7789]

The traceback error given when using the sqlfluff extension is not readily understandable if you don't specify a dialect.

Error text ([username] is a placeholder):
Traceback (most recent call last): File "", line 198, in _run_module_as_main File "", line 88, in run_code File "C:\Users[username]\AppData\Local\Programs\Python\Python312\Scripts\sqlfluff.exe_main.py", line 7, in File "C:\Users[username]\AppData\Local\Programs\Python\Python312\Lib\site-packages\click\core.py", line 1157, in call return self.main(*args, **kwargs) ^^^^^^^^^^^ ^^^^^^^^^^^^^^^ File "C:\Users[username]\AppData\Local\Programs\Python\Python312\Lib\site-packages\click\core.py", line 1078, in main rv = self.invoke(ctx) ^^^^^^^^^^^^^^^^ File "C:\Users[username]\AppData\Local\Programs\Python\Python312\Lib\site-packages\click\core.py", line 1688, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users[username]\AppData\Local\Programs\Python\Python312\Lib\site-packages\click\core.py", line 1434...

After specifying a dialect (ex. ANSI), the error goes away and the extension works as expected.

Result:

[thijs-nijhuis]

Hi, just installed this beautiful extension (I worked with it in my previous assignment) and I am getting this exact same error message. Unfortunately, setting the dialect doesn't solve it for me. I set it to both 'databricks' and 'ansi'. Apart from this, I have only set the sqlfluff.executablePath since I have sqlfluff installed in a virtual environment.
@dsmith7789, do you have any other settings in there that I might need to set as well?