Dbt core transformation stalling after internal error from Snowflake

The problem I’m having

I am using dbt core along with fivetran to sync data using hvr from sql server to snowflake. Due to internal error in Snowflake: SQL execution internal error:
** Processing aborted due to error 300005:1058028289; incident 7922523.**
The query history showed that the query failed after 2min but the dbt transformation still ran for 23 hours even after snowflake stopped running the query and threw error. Is dbt core not able to capture errors like this one in snowflake?