on_schema change in insert_by_period

[piotrek9721]

Environment

• dbt Version: 1.5.6
• Database: Snowflake

Issue Description

Problem: The "on_schema_change" logic was removed from the insert_by_period materialization macro in a previous version of dbt, and it has not been re-implemented.

Context: We still heavily rely on the insert_by_period materialization, and we believe that adding the "on_schema_change" logic would be beneficial for our use case.

Additional Information

• Attempted Solution: I've tried to add this logic manually, but unfortunately, I couldn't recreate it from the incremental materialization. It appears that it doesn't work for the insert_by_period materialization.

• Request: We would like to know if there are any plans to reintroduce the "on_schema_change" logic to the insert_by_period materialization in future dbt releases.

• Feasibility: Is it technically possible to add the "on_schema_change" logic to the insert_by_period materialization? We'd like to understand any technical limitations or considerations associated with this.

Thank you for considering our request to enhance the insert_by_period materialization with the "on_schema_change" logic. We believe this addition would greatly benefit the dbt community.