CONTACT US: 778-373-4422 | info@mackenziemackenzie.com


Photo by Sangeeth Sangi from Pixabay

How to Use Parameters with Python Connector for Snowflake

25-June-2021
Parameterized queries are very important in the world of data engineering, and it is no different when you’re connecting to your Snowflake database. Luckily, the Snowflake Connector for Python gives us two great ways to use parameters in our queries. These methods will help guard against SQL injection attacks, and will make your queries more robust and efficient. Let’s look at our qmark and numeric parameter styles for querying Snowflake today!



Snowflake Project? Contact me today!

3 Reasons Why You Should Learn Data Techniques

Find 3 big reasons why you should learn data techniques if you are a professional or business person.

Read article

About our workshop

The Professional Problem, 3 Things They Need, and 1 They Don't Have

Why do people constantly run into problems with their data, even when they are highly trained in their area?

Read article

About our workshop

Why Finding Uniqueness is the Key: 6 Methods to Help

Find out why keys and uniqueness are so important for data transformation and data analysis.

Read article

About our workshop

When to Excel and When Not To: Why Specialists Don't Use Excel for Data Transformations

Start your journey in data transformation, and learn why specialists don't use Excel to transform raw data for analysis.

Read article

About our workshop