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


Photo by JL_G from Pixabay

How to Query Snowflake Data into Pandas Dataframes Using fetch_pandas_all

09-Apr-2021
In this episode, we’re going to query our Snowflake database and use fetch_pandas_all to put our result data into a Pandas dataframe. This is a very handy technique that gives you a more usable output (a dataframe) compared to just using fetch_all. Make sure to look at my earlier videos on how to connect to Snowflake and how to install the Snowflake connector. Make sure you install the “pandas friendly” version. (pip install snowflake-connector-python[pandas]



Data Engineering 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