Snowflake Connector for Python
SQL Injection via unescaped DataFrame column names in Snowflake Connector for Python and Snowflake Connector for Python (Universal Core)
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.
Affected versions and mitigation
From the CVE record and the vendor's references.Affected
- >= 2.3.4, < 4.8.1
Fixed in 4.8.1
- >= 5.0.0b1, < 5.2.0
Fixed in 5.2.0
Mitigation
Upgrade Snowflake Connector for Python to 4.8.1 or later.
Upgrade Snowflake Connector for Python (Universal Core) to 5.2.0 or later.
Timeline
Days relative to CVE publicationNo public PoC found yet; not in CISA KEV.
PoC repositories
Found on GitHub.No PoC repositories found yet.