[Feature] Ability to specify CATALOG_SYNC for Iceberg table materialization

[sfc-gh-dyaroshenko]

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-snowflake functionality, rather than a Big Idea better suited to a discussion

Describe the feature

Snowflake Iceberg table materialization is great. Works like a charm creating table and registering it in Snowflake catalog.
It will be really great to be able to support the option that synchronise newly created table with Polaris catalog.
Looks like technically we have everything but the CATALOG_SYNC parameter. Hopefully this is something that can be easily added.
Snowflake documentation with example:
https://docs.snowflake.com/user-guide/tables-iceberg-polaris-sync#step-4-create-a-snowflake-managed-table
Thanks!

Describe alternatives you've considered

Potentially can be done using post-hook

Who will this benefit?

Ever growing Polaris community

Are you interested in contributing this feature?

No response

Anything else?

https://docs.snowflake.com/user-guide/tables-iceberg-polaris-sync#step-4-create-a-snowflake-managed-table
Thank you!