[Feature] Reduce warnings with singular restrict_direct_pg_catalog_access message

[FridayPush]

Is this your first time submitting a feature request?

• I have read the expectations for open source contributors
• I have searched the existing issues, and I could not find an existing issue for this feature
• I am requesting a straightforward extension of existing dbt-redshift functionality, rather than a Big Idea better suited to a discussion

Describe the feature

I have many hundreds of warnings for restrict_direct_pg_catalog_access behavior changes and it makes it impossible to see the warnings I care about related to tests and freshness/etc. Can the warning behavior be adjusted to reduce the messages to once per job run, rather than once per model materialization.

Describe alternatives you've considered

A single warning at the Top of a dbt run, perhaps when the compile step happens or the internal calls to determine if the tables already exist or not is performed.

Who will this benefit?

Administrators of job runs that need to action on Warnings.

Are you interested in contributing this feature?

I'm not able to

Anything else?

No response