Good Morning. With Elementary 0.14.1, we are getting an internal Snowflake error of the enriched_columns model refresh. If we exclude that specific model, all others refresh fine. Based on response from Snowflake support, the error is related to the parsing the view definition. We have around 1400 models currently. Seems like this would be a bug for any Elementary users on Snowflake with a large number of models The error:

17:15:09  Completed with 1 error and 0 warnings:
17:15:09
17:15:09    Database Error in model enriched_columns (models\edr\dbt_artifacts\enriched_columns.sql)
  000603 (XX000): SQL execution internal error:
  Processing aborted due to error 300002:3382095835; incident 4110612.
  compiled Code at target\run\elementary\models\edr\dbt_artifacts\enriched_columns.sql
17:15:09
17:15:09  Done. PASS=0 WARN=0 ERROR=1 SKIP=0 TOTAL=1

Snowflake support response:

Issue:  It's happening when creating views with large definition or functions with large body or adding columns with large name. we hear you, Snowflake is working constantly to improve error message. 

It has hit a hard system internal limit to increase it further. 

Options Available: will it be possible to shrink the view definition or build intermediate tables?

@Robert O Thats interesting, I would love it if you could create a Github issue regarding this topic 🙏 in the meantime, you can disable that model