What would you recommend as the best Python library and Python version for ingesting data from Hadoop to Snowflake?

I want to place the output of query to dataframe then ingest it to Snowflake.