SQL execution of dbt deps fails

[SudoCerb]

Hello,

I have successfully deployed a dbt project from my workspace but I want to fully automate the process.

I’ve encountered an issue when creating or altering a dbt project - dep installations do not work. I am able to go into my workspace, and deploy the project from there after running dbt deps in there, but this defeats the point of automation.

My user and role have the necessary privileges.

Here’s a snippet of my commands:

ALTER GIT FOO_DB.BAR_SCHEMA.FIZZ_GIT_REPO FETCH;

ALTER DBT PROJECT FOO_DB.BAR_SCHEMA.BAZ_DBT_PROJECT ADD VERSION FROM @foo_db.bar_schema.fizz_git_repo/branches/"dev";

-- the below appears to run successfully, not raising any errors, STDOUT shows the expected lines "Installing from... etc."
EXECUTE DBT PROJECT FOO_DB.BAR_SCHEMA.BAZ_DBT_PROJECT args='deps -t dev' external_access_integrations = (DBT_EXT_ACCESS);

EXECUTE DBT PROJECT FOO_DB.BAR_SCHEMA.BAZ_DBT_PROJECT args='run -t dev -x -s some.model.somewhere+';
I then get a compilation error:

Compilation Error
dbt found 4 package(s) specified in packages.yml, but only 0 package(s) installed in dbt_packages. Run "dbt deps" to install package dependencies.
I am able to run the model successfully by calling the last SQL command once I’ve ran dbt deps etc. and deployed the project via my workspace.

Any ideas?

[SudoCerb]

Apologies if this is not the correct forum to post in, but I'm desperate.

[SudoCerb]

@iamontheinet I had a look around and saw you recently updated the QS list https://github.com/iamontheinet/quickstarts-on-snowflake

Could you give any guidance or raise this issue with Snowflake devs if it is indeed an issue? I'm pretty stumped at the moment.

I'm sure someone is working on a tutorial for this but if not - it would be so useful to have a step by step guide to interacting with DBT projects and Git repos from SQL commands in Snowflake, as I've been doing in this case.

Let me know if you need any more information or if I can help in some way.

Thanks!