Open SebT84 opened 8 months ago
Have you checked with 'Format Document With...' SQL Fluff is selected?
My project is working without any errors, but I get an error when trying to select the formatter:
Format triggered for ...../processing_dist_score_wtih_catalogue_items.sql
--------------------Executing Command--------------------
http://localhost:8581/format?sql_path=....../processing_dist_score_wtih_catalogue_items.sql
Unhealthy dbt project:
Raw DBT-Interface /format output:
{ "error": { "code": 1, "message": "Sqlfluff currently unavailable. Check that your project does not contain compilation errors.", "data": { "error": "" } } }
System:
Setup: I've installed SQLfluff on VS code so I can format my code, this is set as part of a .sqlfluff file that is un a repo. The path to the .sqlfluff has been update in VS code File > Preferences > Settings > Extensions > SQLfluff under 'Specify an additional configuration file that overrides the standard configuration files.' .
Issue: When doing right click 'format document' on some SQl view that we know don't have the right format, nothing happen. we would expect some issues to come up under the 'PROBLEMS' tab in vs code. We've also tried to run it in the command line with
sqlfluff lint create_view_V_SALE_NR.sql --dialect snowflake
and it works.