Decoded: Small Business Cybersecurity News & Insights

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:

  • Crypto Regulation in 2025: What You Need to Know

    Cryptocurrency regulation in 2025 looks less like a wild west shootout and more like a paperwork-laden chess match. As the digital asset industry matures, governments around the world are trying to fit crypto into traditional legal frameworks. Some are doing this with a sledgehammer. Others, with a scalpel.

  • How to Secure Your Wi-Fi Network Against Cyber Threats

    Your Wi-Fi network is like the front door to your digital home. If you leave it open, strangers may wander in. This guide shows you how to lock that door and keep unwanted guests out. I promise this guide is clear. Even I had to reread it once or twice (and that was a slow…

  • 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…