SQLfluff is looking for profiles.yml for dbt cloud connection

[AWaleczek]

Hello,

I am using dbt power user in VS code with dbt cloud, Snowflake and try to get SQLfluff going.

I have the SQLfluff extension installed, and use the dbt templater as per these instructions: https://docs.sqlfluff.com/en/stable/configuration/templating/dbt.html

I tired various configurations for this part:

[sqlfluff:templater:dbt]
project_dir = <relative or absolute path to dbt_project directory>
profiles_dir = <relative or absolute path to the directory that contains the profiles.yml file>
profile = <dbt profile>
target = <dbt target>

but always end up with this error

To me it seems like SQLfluff is looking for a profiles.yml although I don't have one since I connect to dbt cloud.
I couldn't find a setting to tweak this behaviour.

This is how my .sqlfluff file looks otherwise:

[sqlfluff]
templater = dbt

[sqlfluff:templater:jinja]
apply_dbt_builtins = True

[sqlfluff:templater:jinja:macros]
# Macros provided as builtins for dbt projects
dbt_ref = {% macro ref(model_ref) %}{{model_ref}}{% endmacro %}
dbt_source = {% macro source(source_name, table) %}{{source_name}}_{{table}}{% endmacro %}
dbt_config = {% macro config() %}{% for k in kwargs %}{% endfor %}{% endmacro %}
dbt_var = {% macro var(variable, default='') %}item{% endmacro %}
dbt_is_incremental = {% macro is_incremental() %}True{% endmacro %}

I'm not sure where else I should look to try to fix this.

[tivoo]

Running into the same error. It seems to be that dbt has a built-in version of sqlfluff which you can run by using dbt sqlfluff format. This send the invocation to the cloud. Now that's why you don't have a profiles.yml. But for some reason I'm unable to configure the extensions to use the built-in dbt command instead of the standalone sqlfluff command. Have you found a solution to this problem yet?

[PedroDaumas]

I'm having the same issue, would be awesome if we could get the extension to use dbt sqlfluff instead of sqlfluff if we are using dbt cloud, maybe have a option in the settings to select dbt cloud vs dbt core