[ADAP-1031] [Bug] send_anonymous_usage_stats ignored for python models

[Dikootje]

Is this a new bug in dbt-snowflake?

• I believe this is a new bug in dbt-snowflake
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

When running python models against Snowflake a telemetry header is added to the procedure.

import sys
sys._xoptions['snowflake_partner_attribution'].append("dbtLabs_dbtPython")

Even with the profiles.yml configured in a what that should prevent this:

config:
  send_anonymous_usage_stats: false

Expected Behavior

When send_anonymous_usage_status is set to false I expect the telemetry snippet not to be inserted in the python code that is send to Snowflake.

dbt-snowflake/dbt/adapters/snowflake/impl.py

Line 222 in f67098d

sys._xoptions['snowflake_partner_attribution'].append("{snowpark_telemetry_string}")"""

Steps To Reproduce

1. Using dbt-core v1.7.0 and dbt-snowflake v1.7.0
2. Create any python model
3. Execute using Snowflake
4. Look up the query in the snowflake query history

Relevant log output

No response

Environment

- OS: any
- Python: 3.11
- dbt-core: 1.7.0
- dbt-snowflake: 1.7.0

Additional Context

When auditing the Snowflake query log, we've discovered that dbt usage is being tracked even when this is set specifically to false in the dbt profiles.yml.

[dbeatty10]

Thanks you for reporting this @Dikootje !

Acceptance criteria

• send_anonymous_usage_stats config is respected for dbt-snowflake
• When true, dbt usage will show in the Snowflake query log
• When false, dbt usage will not show in the Snowflake query log (because it is not being tracked)

[mikealfare]

Re-opening for backport