I am trying to deploy sql model to snowflake using config block, however DBT does not take the details from config object when deploying

I have been trying to connect to snowflake with dbt but I seem to be getting this error

While creating my project, I have provided a default schema name from Snowflake to work in the project, let’s call it DEFAULT_SCHEMA,
I tried updating the schema to a different one for SEEDS in dbt_project.yml,

I’m working with dbt and Snowflake and need to create a custom materialization for managing database sequences. Since dbt’s built-in materializations are intended for tables and views, I’m having trouble adapting them for sequences.

Currently, I have a DBT project for Snowflake which uses streams, views, tasks and procedures, every time the project runs my views are re-created and the streams that use those views stop working, this is normal functionality of Snowflake stream, is there a way to perform the action CREATE IF NOT EXISTS VIEW in dbt data model?

I am having trouble refreshing Dynamic Tables in Snowflake using dbt core .
My dbt core versions are as follows
Core:

The requirement is to use a dynamic variable in posthook, I just don’t know if its possible in dbt model

Running dbt core version 1.6.10 and Snowflake

I have a source table named group.

When I execute dbt run... command I get “…unexpected group.” error.

I have an incremental model in dbt that uses the data of a stream (as a source) and tries to merge into a next table.

Running dbt core version 1.6.10 and Snowflake

I have a source table named group.

When I execute dbt run... command I get “…unexpected group.” error.