This PR was automatically created by Snyk using the credentials of a real user.
Snyk has created this PR to fix one or more vulnerable packages in the `pip` dependencies of this project.
#### Changes included in this PR
- Changes to the following files to upgrade the vulnerable dependencies to a fixed version:
- etl/requirements.txt
⚠️ Warning
```
openai 0.27.8 requires aiohttp, which is not installed.
lambdaprompt 0.4.2 requires aiohttp, which is not installed.
```
#### Vulnerabilities that will be fixed
##### By pinning:
Severity | Issue | Upgrade | Breaking Change | Exploit Maturity
:-------------------------:|:-------------------------|:-------------------------|:-------------------------|:-------------------------
 | Insufficient Verification of Data Authenticity [SNYK-PYTHON-CERTIFI-3164749](https://snyk.io/vuln/SNYK-PYTHON-CERTIFI-3164749) | `certifi:` `2021.10.8 -> 2023.7.22` | No | No Known Exploit
 | Improper Following of a Certificate's Chain of Trust [SNYK-PYTHON-CERTIFI-5805047](https://snyk.io/vuln/SNYK-PYTHON-CERTIFI-5805047) | `certifi:` `2021.10.8 -> 2023.7.22` | No | No Known Exploit
 | Denial of Service (DoS) [SNYK-PYTHON-CRYPTOGRAPHY-3172287](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-3172287) | `cryptography:` `3.3.2 -> 42.0.2` | No | No Known Exploit
 | Expected Behavior Violation [SNYK-PYTHON-CRYPTOGRAPHY-3314966](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-3314966) | `cryptography:` `3.3.2 -> 42.0.2` | No | No Known Exploit
 | Use After Free [SNYK-PYTHON-CRYPTOGRAPHY-3315324](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-3315324) | `cryptography:` `3.3.2 -> 42.0.2` | No | Proof of Concept
 | Access of Resource Using Incompatible Type ('Type Confusion') [SNYK-PYTHON-CRYPTOGRAPHY-3315328](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-3315328) | `cryptography:` `3.3.2 -> 42.0.2` | No | No Known Exploit
 | Timing Attack [SNYK-PYTHON-CRYPTOGRAPHY-3315331](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-3315331) | `cryptography:` `3.3.2 -> 42.0.2` | No | No Known Exploit
 | Denial of Service (DoS) [SNYK-PYTHON-CRYPTOGRAPHY-3315452](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-3315452) | `cryptography:` `3.3.2 -> 42.0.2` | No | No Known Exploit
 | Denial of Service (DoS) [SNYK-PYTHON-CRYPTOGRAPHY-3315972](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-3315972) | `cryptography:` `3.3.2 -> 42.0.2` | No | No Known Exploit
 | Denial of Service (DoS) [SNYK-PYTHON-CRYPTOGRAPHY-3315975](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-3315975) | `cryptography:` `3.3.2 -> 42.0.2` | No | No Known Exploit
 | Denial of Service (DoS) [SNYK-PYTHON-CRYPTOGRAPHY-3316038](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-3316038) | `cryptography:` `3.3.2 -> 42.0.2` | No | No Known Exploit
 | Denial of Service (DoS) [SNYK-PYTHON-CRYPTOGRAPHY-3316211](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-3316211) | `cryptography:` `3.3.2 -> 42.0.2` | No | No Known Exploit
 | Denial of Service (DoS) [SNYK-PYTHON-CRYPTOGRAPHY-5663682](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-5663682) | `cryptography:` `3.3.2 -> 42.0.2` | No | No Known Exploit
 | Improper Certificate Validation [SNYK-PYTHON-CRYPTOGRAPHY-5777683](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-5777683) | `cryptography:` `3.3.2 -> 42.0.2` | No | Proof of Concept
 | Insufficient Verification of Data Authenticity [SNYK-PYTHON-CRYPTOGRAPHY-5813745](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-5813745) | `cryptography:` `3.3.2 -> 42.0.2` | No | No Known Exploit
 | Denial of Service (DoS) [SNYK-PYTHON-CRYPTOGRAPHY-5813746](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-5813746) | `cryptography:` `3.3.2 -> 42.0.2` | No | No Known Exploit
 | Denial of Service (DoS) [SNYK-PYTHON-CRYPTOGRAPHY-5813750](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-5813750) | `cryptography:` `3.3.2 -> 42.0.2` | No | No Known Exploit
 | Denial of Service (DoS) [SNYK-PYTHON-CRYPTOGRAPHY-5914629](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-5914629) | `cryptography:` `3.3.2 -> 42.0.2` | No | No Known Exploit
 | Missing Cryptographic Step [SNYK-PYTHON-CRYPTOGRAPHY-6036192](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-6036192) | `cryptography:` `3.3.2 -> 42.0.2` | No | No Known Exploit
 | Denial of Service (DoS) [SNYK-PYTHON-CRYPTOGRAPHY-6050294](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-6050294) | `cryptography:` `3.3.2 -> 42.0.2` | No | No Known Exploit
 | NULL Pointer Dereference [SNYK-PYTHON-CRYPTOGRAPHY-6092044](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-6092044) | `cryptography:` `3.3.2 -> 42.0.2` | No | Proof of Concept
 | Information Exposure [SNYK-PYTHON-CRYPTOGRAPHY-6126975](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-6126975) | `cryptography:` `3.3.2 -> 42.0.2` | No | Proof of Concept
 | NULL Pointer Dereference [SNYK-PYTHON-CRYPTOGRAPHY-6210214](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-6210214) | `cryptography:` `3.3.2 -> 42.0.2` | No | No Known Exploit
 | Information Exposure [SNYK-PYTHON-REQUESTS-5595532](https://snyk.io/vuln/SNYK-PYTHON-REQUESTS-5595532) | `requests:` `2.27.1 -> 2.31.0` | No | No Known Exploit
 | Regular Expression Denial of Service (ReDoS) [SNYK-PYTHON-SETUPTOOLS-3180412](https://snyk.io/vuln/SNYK-PYTHON-SETUPTOOLS-3180412) | `setuptools:` `39.0.1 -> 65.5.1` | No | No Known Exploit
 | Regular Expression Denial of Service (ReDoS) [SNYK-PYTHON-WHEEL-3180413](https://snyk.io/vuln/SNYK-PYTHON-WHEEL-3180413) | `wheel:` `0.30.0 -> 0.38.0` | No | No Known Exploit
Some vulnerabilities couldn't be fully fixed and so Snyk will still find them when the project is tested again. This may be because the vulnerability existed within more than one direct dependency, but not all of the affected dependencies could be upgraded.
Check the changes in this PR to ensure they won't cause issues with your project.
------------
**Note:** *You are seeing this because you or someone else with access to this repository has authorized Snyk to open fix PRs.*
For more information:
🧐 [View latest project report](https://app.snyk.io/org/billmetangmo/project/6eb5ec1c-dedd-4d65-8d5b-1a10f3ae5304?utm_source=github&utm_medium=referral&page=fix-pr)
🛠 [Adjust project settings](https://app.snyk.io/org/billmetangmo/project/6eb5ec1c-dedd-4d65-8d5b-1a10f3ae5304?utm_source=github&utm_medium=referral&page=fix-pr/settings)
📚 [Read more about Snyk's upgrade and patch logic](https://support.snyk.io/hc/en-us/articles/360003891078-Snyk-patches-to-fix-vulnerabilities)
[//]: # (snyk:metadata:{"prId":"fe793140-79b1-4266-a73e-91967249dccb","prPublicId":"fe793140-79b1-4266-a73e-91967249dccb","dependencies":[{"name":"certifi","from":"2021.10.8","to":"2023.7.22"},{"name":"cryptography","from":"3.3.2","to":"42.0.2"},{"name":"requests","from":"2.27.1","to":"2.31.0"},{"name":"setuptools","from":"39.0.1","to":"65.5.1"},{"name":"wheel","from":"0.30.0","to":"0.38.0"}],"packageManager":"pip","projectPublicId":"6eb5ec1c-dedd-4d65-8d5b-1a10f3ae5304","projectUrl":"https://app.snyk.io/org/billmetangmo/project/6eb5ec1c-dedd-4d65-8d5b-1a10f3ae5304?utm_source=github&utm_medium=referral&page=fix-pr","type":"auto","patch":[],"vulns":["SNYK-PYTHON-CERTIFI-3164749","SNYK-PYTHON-CERTIFI-5805047","SNYK-PYTHON-CRYPTOGRAPHY-3172287","SNYK-PYTHON-CRYPTOGRAPHY-3314966","SNYK-PYTHON-CRYPTOGRAPHY-3315324","SNYK-PYTHON-CRYPTOGRAPHY-3315328","SNYK-PYTHON-CRYPTOGRAPHY-3315331","SNYK-PYTHON-CRYPTOGRAPHY-3315452","SNYK-PYTHON-CRYPTOGRAPHY-3315972","SNYK-PYTHON-CRYPTOGRAPHY-3315975","SNYK-PYTHON-CRYPTOGRAPHY-3316038","SNYK-PYTHON-CRYPTOGRAPHY-3316211","SNYK-PYTHON-CRYPTOGRAPHY-5663682","SNYK-PYTHON-CRYPTOGRAPHY-5777683","SNYK-PYTHON-CRYPTOGRAPHY-5813745","SNYK-PYTHON-CRYPTOGRAPHY-5813746","SNYK-PYTHON-CRYPTOGRAPHY-5813750","SNYK-PYTHON-CRYPTOGRAPHY-5914629","SNYK-PYTHON-CRYPTOGRAPHY-6036192","SNYK-PYTHON-CRYPTOGRAPHY-6050294","SNYK-PYTHON-CRYPTOGRAPHY-6092044","SNYK-PYTHON-CRYPTOGRAPHY-6126975","SNYK-PYTHON-CRYPTOGRAPHY-6210214","SNYK-PYTHON-REQUESTS-5595532","SNYK-PYTHON-SETUPTOOLS-3180412","SNYK-PYTHON-WHEEL-3180413"],"upgrade":[],"isBreakingChange":false,"env":"prod","prType":"fix","templateVariants":["pr-warning-shown"],"priorityScoreList":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"remediationStrategy":"vuln"})
---
**Learn how to fix vulnerabilities with free interactive lessons:**
🦉 [Use After Free](https://learn.snyk.io/lesson/use-after-free/?loc=fix-pr)
🦉 [Access of Resource Using Incompatible Type ('Type Confusion')](https://learn.snyk.io/lesson/type-confusion/?loc=fix-pr)
🦉 [Denial of Service (DoS)](https://learn.snyk.io/lesson/redos/?loc=fix-pr)
🦉 [More lessons are available in Snyk Learn](https://learn.snyk.io/?loc=fix-pr)
This PR was automatically created by Snyk using the credentials of a real user.
Snyk has created this PR to fix one or more vulnerable packages in the `pip` dependencies of this project.
#### Changes included in this PR - Changes to the following files to upgrade the vulnerable dependencies to a fixed version: - etl/requirements.txt⚠️ Warning
``` openai 0.27.8 requires aiohttp, which is not installed. lambdaprompt 0.4.2 requires aiohttp, which is not installed. ```[SNYK-PYTHON-CERTIFI-3164749](https://snyk.io/vuln/SNYK-PYTHON-CERTIFI-3164749) | `certifi:`
`2021.10.8 -> 2023.7.22`
| No | No Known Exploit  | Improper Following of a Certificate's Chain of Trust
[SNYK-PYTHON-CERTIFI-5805047](https://snyk.io/vuln/SNYK-PYTHON-CERTIFI-5805047) | `certifi:`
`2021.10.8 -> 2023.7.22`
| No | No Known Exploit  | Denial of Service (DoS)
[SNYK-PYTHON-CRYPTOGRAPHY-3172287](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-3172287) | `cryptography:`
`3.3.2 -> 42.0.2`
| No | No Known Exploit  | Expected Behavior Violation
[SNYK-PYTHON-CRYPTOGRAPHY-3314966](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-3314966) | `cryptography:`
`3.3.2 -> 42.0.2`
| No | No Known Exploit  | Use After Free
[SNYK-PYTHON-CRYPTOGRAPHY-3315324](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-3315324) | `cryptography:`
`3.3.2 -> 42.0.2`
| No | Proof of Concept  | Access of Resource Using Incompatible Type ('Type Confusion')
[SNYK-PYTHON-CRYPTOGRAPHY-3315328](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-3315328) | `cryptography:`
`3.3.2 -> 42.0.2`
| No | No Known Exploit  | Timing Attack
[SNYK-PYTHON-CRYPTOGRAPHY-3315331](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-3315331) | `cryptography:`
`3.3.2 -> 42.0.2`
| No | No Known Exploit  | Denial of Service (DoS)
[SNYK-PYTHON-CRYPTOGRAPHY-3315452](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-3315452) | `cryptography:`
`3.3.2 -> 42.0.2`
| No | No Known Exploit  | Denial of Service (DoS)
[SNYK-PYTHON-CRYPTOGRAPHY-3315972](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-3315972) | `cryptography:`
`3.3.2 -> 42.0.2`
| No | No Known Exploit  | Denial of Service (DoS)
[SNYK-PYTHON-CRYPTOGRAPHY-3315975](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-3315975) | `cryptography:`
`3.3.2 -> 42.0.2`
| No | No Known Exploit  | Denial of Service (DoS)
[SNYK-PYTHON-CRYPTOGRAPHY-3316038](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-3316038) | `cryptography:`
`3.3.2 -> 42.0.2`
| No | No Known Exploit  | Denial of Service (DoS)
[SNYK-PYTHON-CRYPTOGRAPHY-3316211](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-3316211) | `cryptography:`
`3.3.2 -> 42.0.2`
| No | No Known Exploit  | Denial of Service (DoS)
[SNYK-PYTHON-CRYPTOGRAPHY-5663682](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-5663682) | `cryptography:`
`3.3.2 -> 42.0.2`
| No | No Known Exploit  | Improper Certificate Validation
[SNYK-PYTHON-CRYPTOGRAPHY-5777683](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-5777683) | `cryptography:`
`3.3.2 -> 42.0.2`
| No | Proof of Concept  | Insufficient Verification of Data Authenticity
[SNYK-PYTHON-CRYPTOGRAPHY-5813745](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-5813745) | `cryptography:`
`3.3.2 -> 42.0.2`
| No | No Known Exploit  | Denial of Service (DoS)
[SNYK-PYTHON-CRYPTOGRAPHY-5813746](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-5813746) | `cryptography:`
`3.3.2 -> 42.0.2`
| No | No Known Exploit  | Denial of Service (DoS)
[SNYK-PYTHON-CRYPTOGRAPHY-5813750](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-5813750) | `cryptography:`
`3.3.2 -> 42.0.2`
| No | No Known Exploit  | Denial of Service (DoS)
[SNYK-PYTHON-CRYPTOGRAPHY-5914629](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-5914629) | `cryptography:`
`3.3.2 -> 42.0.2`
| No | No Known Exploit  | Missing Cryptographic Step
[SNYK-PYTHON-CRYPTOGRAPHY-6036192](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-6036192) | `cryptography:`
`3.3.2 -> 42.0.2`
| No | No Known Exploit  | Denial of Service (DoS)
[SNYK-PYTHON-CRYPTOGRAPHY-6050294](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-6050294) | `cryptography:`
`3.3.2 -> 42.0.2`
| No | No Known Exploit  | NULL Pointer Dereference
[SNYK-PYTHON-CRYPTOGRAPHY-6092044](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-6092044) | `cryptography:`
`3.3.2 -> 42.0.2`
| No | Proof of Concept  | Information Exposure
[SNYK-PYTHON-CRYPTOGRAPHY-6126975](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-6126975) | `cryptography:`
`3.3.2 -> 42.0.2`
| No | Proof of Concept  | NULL Pointer Dereference
[SNYK-PYTHON-CRYPTOGRAPHY-6210214](https://snyk.io/vuln/SNYK-PYTHON-CRYPTOGRAPHY-6210214) | `cryptography:`
`3.3.2 -> 42.0.2`
| No | No Known Exploit  | Information Exposure
[SNYK-PYTHON-REQUESTS-5595532](https://snyk.io/vuln/SNYK-PYTHON-REQUESTS-5595532) | `requests:`
`2.27.1 -> 2.31.0`
| No | No Known Exploit  | Regular Expression Denial of Service (ReDoS)
[SNYK-PYTHON-SETUPTOOLS-3180412](https://snyk.io/vuln/SNYK-PYTHON-SETUPTOOLS-3180412) | `setuptools:`
`39.0.1 -> 65.5.1`
| No | No Known Exploit  | Regular Expression Denial of Service (ReDoS)
[SNYK-PYTHON-WHEEL-3180413](https://snyk.io/vuln/SNYK-PYTHON-WHEEL-3180413) | `wheel:`
`0.30.0 -> 0.38.0`
| No | No Known Exploit Some vulnerabilities couldn't be fully fixed and so Snyk will still find them when the project is tested again. This may be because the vulnerability existed within more than one direct dependency, but not all of the affected dependencies could be upgraded. Check the changes in this PR to ensure they won't cause issues with your project. ------------ **Note:** *You are seeing this because you or someone else with access to this repository has authorized Snyk to open fix PRs.* For more information: