Bug: make warehouse models pass sqlfluff linter 3.0.6 rules

[tiffanychu90]

Describe the bug
We have updated our sqlfluff linter to 3.0.6, and there are some rules that now create errors that we may want to adhere to. We might add some to our exclusion list, but there are some we might want to fix across all the models.

Previous bug issue #3343

To Reproduce
If we run CI on warehouse/models/, we'll get a lot of new rules and CI will not pass.

Expected behavior
We want all our warehouse/models to pass.

Additional context

[tiffanychu90]

Closing -- did not notice this file that replaces the commented out lines in pre-commit-config