What is the current behavior?
In the function write_pandas there is no way to leverage the param USE_VECTORIZED_SCANNER.
What is the desired behavior?
Snowflake recently published a blog about the ability to leverage the parameter USE_VECTORIZED_SCANNER for performance improvements.
We should have the option to leverage this parameter to help with performance
How would this improve snowflake-connector-python?
Help with performance
References and other background
https://www.snowflake.com/en/engineering-blog/loading-terabytes-into-snowflake-speeds-feeds-techniques/