[CT-2167] Enforce model contracts for default view materializations

[MichelleArk]

Currently, we assert column equivalence during table creation.

We'll need to similarly assert column equivalence in default view materializations.

Note - we won't be able to generate column_spec_ddl as column spec ddl is generally unsupported for view creation.

[emmyoop]

Also add tests but they can follow the pattern for the table version but for a view.