Is your feature request related to a problem? Please describe.
For folks on data bricks or other spark-based platforms, getting large data as a pandas df may not be an option .... It's possible to get a spark df using Snowflake Connector for Python but it's orders of magnitude slower compared to Snowflake connector for Spark
Describe the solution you'd like
Add a function to SnowflakeRetrievalJob which supports executing & retrieving snowflake query through Snowflake Connector for Spark
Describe alternatives you've considered
Tried getting snowflake query results as arrow_batches -> converting to pandas on each batch -> to spark data frame -> concatenate all spark dos to one. This is orders go marinated slower than reading same data frame from Snowflake Connector for Spark.
cc: @sfc-gh-madkins
Is your feature request related to a problem? Please describe.
For folks on data bricks or other spark-based platforms, getting large data as a pandas df may not be an option .... It's possible to get a
spark dfusingSnowflake Connector for Pythonbut it's orders of magnitude slower compared toSnowflake connector for SparkDescribe the solution you'd like
Add a function to
SnowflakeRetrievalJobwhich supports executing & retrieving snowflake query throughSnowflake Connector for SparkDescribe alternatives you've considered
Tried getting snowflake query results as
arrow_batches-> converting to pandas on each batch -> to spark data frame -> concatenate all spark dos to one. This is orders go marinated slower than reading same data frame fromSnowflake Connector for Spark.cc: @sfc-gh-madkins