Amazon Redshift Python Connector Vulnerability: SQL Injection

Published Date: December 27, 2024

Package Affected Versions Patched Versions Severity
📦 redshift_connector (pip) = 2.1.4 2.1.5 High

Description

Summary


A SQL injection vulnerability exists in Amazon Redshift Python Connector version 2.1.4. Attackers can exploit this flaw using the get_schemas, get_tables, or get_columns Metadata APIs to gain escalated privileges.

Immediate Action: Upgrade to version 2.1.5 or revert to version 2.1.3.




Impact


When using Metadata APIs (get_schemas, get_tables, get_columns), unvalidated inputs can be injected into SQL queries, potentially allowing an attacker to manipulate database commands.

Patches & Workarounds

Fix Details (Patched in 2.1.5)



  • All metadata command inputs are now parameterized queries.

  • Inputs are passed securely using QUOTE_IDENT(string) or QUOTE_LITERAL(string) to prevent injection.

  • Commands are composed only after sanitizing all inputs.






Workaround (If Immediate Upgrade Isn’t Possible)



  • Downgrade to version 2.1.3, which does not have this vulnerability.


Upgrade Command:

pip install redshift_connector==2.1.5


Downgrade Command:

pip install redshift_connector==2.1.3

References

https://nvd.nist.gov/vuln/detail/CVE-2024-12745

https://aws.amazon.com/security/security-bulletins/AWS-2024-015
Share this:
  • Cybersecurity Risks of U.S. Trade Tariffs: Impact on Supply Chains in Canada, Mexico & the EU

    In early 2025, the U.S. government announced new tariffs aimed at Canada, Mexico, and potentially the European Union. While the tariffs on Canada and Mexico are temporarily on hold, businesses are already adjusting supply chains to prepare for the financial impact. Trade policies like these cause ripple effects across industries, and cybersecurity often takes a…

  • Dark Web & Small Businesses: How Hackers Sell Your Data

    Many small business owners assume that cyberattacks only target large corporations. They imagine hackers as shadowy figures breaching high-security networks of multinational companies. The reality is much bleaker: small businesses are prime targets because they often lack strong cybersecurity defenses. Worse, once stolen, their data often ends up for sale on the dark web.

  • Top 10 Viruses and Malware Wreaking Havoc in January 2025

    Learn how to identify and defend against the latest cybersecurity threats like Banshee, Clop Ransomware, and AI-powered attacks. Stay one step ahead of hackers with this detailed guide.

  • Should You Invest in DIY AI Assistants?

    With AI technologies advancing rapidly, there’s growing interest in building personal assistants at home. Today, big names like Alexa and Google Home dominate the market, but their capabilities remain limited by their current integrations. Meanwhile, ChatGPT and Google’s Gemini have revolutionized conversational AI, although they lack standalone devices or wake-word functionality. These limitations won’t last…

  • How Spilled Coffee Saved a Company

    Small businesses face countless threats—phishing attacks, ransomware, budget constraints, and, occasionally, over-caffeinated interns. This is the story of Taxify Associates, a mid-sized accounting firm that narrowly avoided financial ruin thanks to a spilled cup of coffee, a frayed carpet, and one overworked IT manager.

  • How Cybercriminals Bypass Apple iMessage Security Protections

    Cybercriminals have found a simple yet effective way to bypass Apple’s phishing protections built into iMessage. This exploit enables them to trick users into activating dangerous phishing links. As mobile devices dominate how people pay bills, shop, and communicate, phishing attacks (a form of fraudulent message-based scamming) are becoming more popular among bad actors.