Description
When identifier escaping is disabled through a non-default configuration, the write_pandas() data-loading functionality in the Snowflake Connector for Python and the Snowflake Connector for Python (Universal Core) did not escape DataFrame column names before including them in generated SQL, which could allow SQL injection. In both products, a crafted column name could have been used to chain additional SQL statements onto the generated statement, potentially allowing an attacker to read, modify, or delete other data accessible to the application's Snowflake role. Exploitation required an application to pass attacker controlled column names into this functionality. The fix is available in Snowflake Connector for Python version 4.8.1 and Snowflake Connector for Python (Universal Core) version 5.2.0. Users must upgrade manually.
Published: 2026-11-06
Score: 8.1 High
EPSS: n/a
KEV: No
Impact: SQL injection with potential for unauthorized data access or modification
Action: Apply Patch
AI Analysis

Impact

When identifier escaping is disabled via a non‑default configuration, the write_pandas() function in the Snowflake Connector for Python and its Universal Core variant incorporated DataFrame column names into generated SQL without escaping. This flaw can be leveraged to inject arbitrary SQL commands, allowing an attacker who can supply crafted column names to read, alter, or delete data that the application’s Snowflake role is permitted to access.

Affected Systems

Snowflake’s Snowflake Connector for Python (versions prior to 4.8.1) and the Snowflake Connector for Python (Universal Core) (versions prior to 5.2.0) are affected. Users of older connector releases should verify their version and upgrade accordingly.

Risk and Exploitability

The CVSS score of 8.1 indicates a high‑severity vulnerability, and although an EPSS score is not provided, the lack of a KEV listing suggests no confirmed exploitation yet. The vulnerability requires that an attacker can supply column names to write_pandas(), which typically means control over user‑provided data or local code that constructs DataFrames. Thus, the attack vector is typically application‑level and may be mitigated by enforcing proper escaping or by limiting exposure of write_pandas().

Generated by OpenCVE AI on November 6, 2026 at 17:50 UTC.

Remediation

No solution or workaround provided in the CVE record.

OpenCVE Recommended Actions

  • Upgrade the Snowflake Connector for Python to at least version 4.8.1.
  • Upgrade the Snowflake Connector for Python (Universal Core) to at least version 5.2.0.
  • Ensure that the configuration parameter for identifier escaping is left enabled and not disabled in any custom settings.

Generated by OpenCVE AI on November 6, 2026 at 17:50 UTC.

Tracking

Sign in to view the affected projects.

Advisories

No advisories yet.

History

Fri, 06 Nov 2026 16:30:00 +0000

Type Values Removed Values Added
Description When identifier escaping is disabled through a non-default configuration, the write_pandas() data-loading functionality in the Snowflake Connector for Python and the Snowflake Connector for Python (Universal Core) did not escape DataFrame column names before including them in generated SQL, which could allow SQL injection. In both products, a crafted column name could have been used to chain additional SQL statements onto the generated statement, potentially allowing an attacker to read, modify, or delete other data accessible to the application's Snowflake role. Exploitation required an application to pass attacker controlled column names into this functionality. The fix is available in Snowflake Connector for Python version 4.8.1 and Snowflake Connector for Python (Universal Core) version 5.2.0. Users must upgrade manually.
Title SQL Injection via unescaped DataFrame column names in Snowflake Connector for Python and Snowflake Connector for Python (Universal Core)
Weaknesses CWE-89
References
Metrics cvssV3_1

{'score': 8.1, 'vector': 'CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:H/I:H/A:H'}


Subscriptions

No data.

cve-icon MITRE

Status: PUBLISHED

Assigner: SNOWFLAKE

Published:

Updated: 2026-11-06T16:45:01.480Z

Reserved: 2026-11-06T16:06:29.814Z

Link: CVE-2026-123859

cve-icon Vulnrichment

No data.

cve-icon NVD

Status : Received

Published: 2026-11-06T17:17:25.323

Modified: 2026-11-06T17:17:25.323

Link: CVE-2026-123859

cve-icon Redhat

No data.

cve-icon OpenCVE Enrichment

Updated: 2026-11-06T18:00:10Z

Weaknesses
  • CWE-89

    Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')