Skip to content
OpenAdvisories
High · 7.5 GHSA-p72q-h37j-3hq7

dbt uses a SQLparse version with a high vulnerability

Published Apr 22, 2024 · Updated Dec 5, 2024 · Assigned by GHSA

Description

### 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:
```sh
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:

```python
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](https://github.com/dbt-labs/dbt-core/releases/tag/v1.6.13) and [dbt-core v1.7.13](https://github.com/dbt-labs/dbt-core/releases/tag/v1.7.13).

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

Affected packages

EcosystemPackageAffectedFixedRecord
PyPI dbt-core >= 1.6.0, < 1.6.13 1.6.13 GHSA-p72q-h37j-3hq7
PyPI dbt-core >= 1.7.0, < 1.7.13 1.7.13 GHSA-p72q-h37j-3hq7

References