[Templater: dbt] User Error: The dbt templater does not support stdin input, provide a path instead

[moseleyi]

I'm getting this error every time I open a sql file in dbt project. Not sure what to do?

[JunkMyFunk]

Same issue, output from SQLFluff is:

------------------------------------------------------------

Format triggered for /etl/dbt/ssmp/models/looker_explores/explore_product_availability_score.sql

------------------------------------------------------------

Reading from stdin, not file, input may be dirty/partial

--------------------Executing Command--------------------

/etl/dbt/ssmp/.venv/bin/sqlfluff fix --stdin-filename dbt/ssmp/models/looker_explores/explore_product_availability_score.sql -

------------------------------------------------------------

Received close event, code 2 signal null
Raw stdout output:

------------------------------------------------------------



------------------------------------------------------------

Raw stderr output:

------------------------------------------------------------


User Error: The dbt templater does not support stdin input, provide a path instead


------------------------------------------------------------

[RobertOstermann]

Do you have the extension configured for DBT?

  "sqlfluff.linter.run": "onSave",
  "sqlfluff.experimental.format.executeInTerminal": true,
  "editor.formatOnSave": false,

[moseleyi]

Surprisingly now no file is detected properly: It's weird since obviously it's a file I opened and its path is correct:

[JunkMyFunk]

I was missing "sqlfluff.experimental.format.executeInTerminal": true, adding this resolved the issue.