[Bug] Python Snowflake Connector deprecating insecure_mode in favor of disable_ocsp_checks - messy logs

### Is this a new bug?

- [x] I believe this is a new bug
- [x] I have searched the existing issues, and I could not find an existing issue for this bug

### Which packages are affected?

- [ ] dbt-adapters
- [ ] dbt-tests-adapter
- [ ] dbt-athena
- [ ] dbt-athena-community
- [ ] dbt-bigquery
- [ ] dbt-postgres
- [ ] dbt-redshift
- [x] dbt-snowflake
- [ ] dbt-spark

### Current Behavior

When running dbt commands, I receive many deprecation warnings, making logs difficult to parse through: `/Users/jasmyn.mudrich/miniconda3/lib/python3.10/site-packages/snowflake/connector/__init__.py:64: DeprecationWarning: The 'insecure_mode' connection property is deprecated. Please use 'disable_ocsp_checks' instead`

Current versions:
- python 3.10.10
- snowflake-connector-python 4.2.0
- dbt-core 1.11.2
- dbt-snowflake 1.11.0

### Expected Behavior

Clean logs!

### Steps To Reproduce

1. Run dbt debug.
- python 3.10.10
- snowflake-connector-python 4.2.0
- dbt-core 1.11.2
- dbt-snowflake 1.11.0

### Relevant log output

```shell

```

### Environment

```markdown
- OS: Mac 26.0
- Python: 3.10.10
- snowflake-connector-python 4.2.0
- dbt-snowflake: 1.11.0
```

### Additional Context

_No response_