Worked on the astronomer/astronomer-cosmos repository to deliver forwarding of the insecure_mode parameter for Snowflake profiles, enhancing connection reliability while maintaining backward compatibility. Implemented in Python, this feature ensures that the insecure_mode setting from Airflow connection Extra is accurately propagated into the dbt profile across all Snowflake mappings. The approach included comprehensive testing, with 55 tests validating both the presence and absence of the parameter, and all code quality checks passing through Black, Ruff, and mypy. This update reduces the risk of dropped settings, minimizes support issues, and allows users to opt into secure profiling without affecting default behavior.