EUVD-2025-19239
GHSA-9r64-3wmc-x8m8
CVSS Vector
CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H
Lifecycle Timeline
4Description
Failure to Sanitize Special Elements into a Different Plane (Special Element Injection) vulnerability in Apache Airflow Providers Snowflake. This issue affects Apache Airflow Providers Snowflake: before 6.4.0. Sanitation of table and stage parameters were added in CopyFromExternalStageToSnowflakeOperator to prevent SQL injection Users are recommended to upgrade to version 6.4.0, which fixes the issue.
Analysis
Apache Airflow Providers Snowflake versions before 6.4.0 contain a Special Element Injection vulnerability (CWE-75) in the CopyFromExternalStageToSnowflakeOperator that fails to properly sanitize table and stage parameters, allowing unauthenticated attackers to execute arbitrary SQL injection attacks with complete system compromise (CVSS 9.8). This is a critical remote vulnerability requiring network access only, with no authentication or user interaction needed, making it a high-priority patch regardless of KEV/EPSS status.
Technical Context
The vulnerability exists in Apache Airflow Providers Snowflake (CPE: pkg:pypi/apache-airflow-providers-snowflake), specifically in the CopyFromExternalStageToSnowflakeOperator class. The root cause is CWE-75 (Failure to Sanitize Special Elements into a Different Plane), which occurs when user-controlled input (table and stage parameters) is concatenated directly into SQL COPY commands without proper parameterization or escaping. Airflow's Snowflake provider constructs dynamic SQL statements for data pipeline operations, and the operator failed to implement input validation before passing these parameters to the Snowflake database connector. The fix involves adding parameterized query handling and special character sanitization to prevent the injection of SQL metacharacters that could alter query logic.
Affected Products
Apache Airflow Providers Snowflake (All versions before 6.4.0)
Remediation
Upgrade to apache-airflow-providers-snowflake version 6.4.0 or later; command: pip install --upgrade apache-airflow-providers-snowflake>=6.4.0; priority: Immediate (within 24-48 hours) Workaround (if immediate patching unavailable): Restrict access to Airflow DAG/API endpoints; implement network segmentation to limit who can trigger CopyFromExternalStageToSnowflakeOperator tasks; audit existing DAGs for user-controlled table/stage parameters; priority: Temporary mitigation only Input Validation (code-level mitigation if patch cannot be applied): Validate table and stage parameter names against whitelists (e.g., alphanumeric + underscore only); avoid dynamic SQL construction without parameterized queries; priority: Secondary defense layer Post-Remediation: Review Airflow logs and Snowflake audit logs for suspicious COPY commands or SQL statements executed between deployment and patching; check for unauthorized schema/table modifications or data exports; priority: High
Priority Score
Share
External POC / Exploit Code
Leaving vuln.today