Ecosyste.ms: Advisories

Security Advisories: GSA_kwCzR0hTQS1wNzJxLWgzN2otM2hxN84AA7Pf

dbt uses a SQLparse version with a high vulnerability

Summary

Using a version of sqlparse that has a security vulnerability and no way to update in current version of dbt core. Snyk recommends using sqlparse==0.5 but this causes a conflict with dbt. Snyk states the issues is a recursion error: SNYK-PYTHON-SQLPARSE-6615674.

Details

Dependency conflict error message:

The conflict is caused by:
    The user requested sqlparse==0.5
    dbt-core 1.7.10 depends on sqlparse<0.5 and >=0.2.3

Resolution was to pin sqlparse >=0.5.0, <0.6.0 in dbt-core, patched in 1.6.13 and 1.7.13.

PoC

From Snyk:

import sqlparse
sqlparse.parse('[' * 10000 + ']' * 10000)

Impact

Snyk classifies it as high 7.5/10.

Patches

The bug has been fixed in dbt-core v1.6.13 and dbt-core v1.7.13.

Mitigations

Bump dbt-core 1.6 and 1.7 dependencies to 1.6.13 and 1.7.13 respectively

Permalink: https://github.com/advisories/GHSA-p72q-h37j-3hq7
JSON: https://advisories.ecosyste.ms/api/v1/advisories/GSA_kwCzR0hTQS1wNzJxLWgzN2otM2hxN84AA7Pf
Source: GitHub Advisory Database
Origin: Unspecified
Severity: High
Classification: General
Published: 7 months ago
Updated: 7 months ago

CVSS Score: 7.5
CVSS vector: CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H

Identifiers: GHSA-p72q-h37j-3hq7
References:

• https://github.com/dbt-labs/dbt-core/security/advisories/GHSA-p72q-h37j-3hq7
• https://security.snyk.io/vuln/SNYK-PYTHON-SQLPARSE-6615674
• https://github.com/andialbrecht/sqlparse/security/advisories/GHSA-2m57-hf25-phgg
• https://github.com/advisories/GHSA-p72q-h37j-3hq7

Repository: https://github.com/dbt-labs/dbt-core
Blast Radius: 20.6

Affected Packages