{"library":"snowpark-connect","title":"Snowpark Connect","type":"library","description":"Snowpark Connect (current version 1.21.1) allows developers to run Snowpark Python code locally using a local Spark cluster, emulating Snowpark functionalities without requiring a direct Snowflake connection. This facilitates offline development, testing, and CI/CD pipelines. It receives updates typically aligned with Snowpark Python and underlying Spark/Snowflake connector releases, and is actively maintained by Snowflake Labs.","language":"python","status":"active","last_verified":"Mon May 18","install":{"commands":["pip install snowpark-connect"],"cli":null},"imports":["from snowpark_connect.session import connect_with_spark_session_builder","from snowpark.snowpark_session import Session","from snowpark.dataframe import DataFrame"],"auth":{"required":false,"env_vars":[]},"links":{"homepage":"https://www.snowflake.com/en/data-cloud/snowpark","github":null,"docs":null,"changelog":null,"pypi":"https://pypi.org/project/snowpark-connect/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null},"quickstart":{"code":"import os\nfrom snowpark_connect.session import connect_with_spark_session_builder\nfrom snowpark.types import StructType, StructField, StringType, IntegerType\n\n# Create a local Spark session that emulates Snowpark behavior\n# Ensure these JARs are compatible with your Spark and Snowflake versions.\nspark_session = connect_with_spark_session_builder(\n    app_name=\"SnowparkConnectLocalApp\",\n    config={\n        \"spark.jars.packages\": \"net.snowflake:snowflake-jdbc:3.13.29,net.snowflake:spark-snowflake_2.12:2.11.0-spark_3.4\",\n        \"spark.jars.repositories\": \"https://repo1.maven.org/maven2\"\n    }\n)\n\n# Use the Spark session to create a Snowpark session\nsession = spark_session.getOrCreateSnowparkSession()\n\n# Example: Create a Snowpark DataFrame and show its content\nschema = StructType([\n    StructField(\"name\", StringType()),\n    StructField(\"age\", IntegerType())\n])\ndata = [(\"Alice\", 30), (\"Bob\", 25)]\ndf = session.create_dataframe(data, schema=schema)\ndf.show()\n\nsession.close()\nspark_session.stop()","lang":"python","description":"This quickstart demonstrates how to initialize a local Snowpark Connect session using `connect_with_spark_session_builder`, create a Snowpark session from it, and perform a basic DataFrame operation. It requires a Java Runtime Environment (JRE) to be installed and `JAVA_HOME` configured for Spark to run.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":{"tag":null,"tag_description":null,"last_tested":"2026-05-18","installed_version":"1.27.0","pypi_latest":"1.27.0","is_stale":false,"summary":{"python_range":"3.10–3.9","success_rate":30,"avg_install_s":46.2,"avg_import_s":null,"wheel_type":"wheel"},"results":[{"runtime":"python:3.10-alpine","python_version":"3.10","os_libc":"alpine (musl)","variant":"snowpark-connect","exit_code":1,"wheel_type":null,"failure_reason":"build_error","import_side_effects":null,"install_time_s":0.1,"import_time_s":null,"mem_mb":null,"disk_size":null},{"runtime":"python:3.10-slim","python_version":"3.10","os_libc":"slim (glibc)","variant":"snowpark-connect","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"broken","install_time_s":48.7,"import_time_s":null,"mem_mb":null,"disk_size":"643M"},{"runtime":"python:3.11-alpine","python_version":"3.11","os_libc":"alpine (musl)","variant":"snowpark-connect","exit_code":1,"wheel_type":null,"failure_reason":"build_error","import_side_effects":null,"install_time_s":0.1,"import_time_s":null,"mem_mb":null,"disk_size":null},{"runtime":"python:3.11-slim","python_version":"3.11","os_libc":"slim (glibc)","variant":"snowpark-connect","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"broken","install_time_s":47.5,"import_time_s":null,"mem_mb":null,"disk_size":"687M"},{"runtime":"python:3.12-alpine","python_version":"3.12","os_libc":"alpine (musl)","variant":"snowpark-connect","exit_code":1,"wheel_type":null,"failure_reason":"build_error","import_side_effects":null,"install_time_s":0.1,"import_time_s":null,"mem_mb":null,"disk_size":null},{"runtime":"python:3.12-slim","python_version":"3.12","os_libc":"slim (glibc)","variant":"snowpark-connect","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"broken","install_time_s":42.4,"import_time_s":null,"mem_mb":null,"disk_size":"676M"},{"runtime":"python:3.13-alpine","python_version":"3.13","os_libc":"alpine (musl)","variant":"snowpark-connect","exit_code":1,"wheel_type":null,"failure_reason":"build_error","import_side_effects":null,"install_time_s":null,"import_time_s":null,"mem_mb":null,"disk_size":null},{"runtime":"python:3.13-slim","python_version":"3.13","os_libc":"slim (glibc)","variant":"snowpark-connect","exit_code":1,"wheel_type":null,"failure_reason":"build_error","import_side_effects":null,"install_time_s":1.4,"import_time_s":null,"mem_mb":null,"disk_size":null},{"runtime":"python:3.9-alpine","python_version":"3.9","os_libc":"alpine (musl)","variant":"snowpark-connect","exit_code":1,"wheel_type":null,"failure_reason":"build_error","import_side_effects":null,"install_time_s":null,"import_time_s":null,"mem_mb":null,"disk_size":null},{"runtime":"python:3.9-slim","python_version":"3.9","os_libc":"slim (glibc)","variant":"snowpark-connect","exit_code":1,"wheel_type":null,"failure_reason":"build_error","import_side_effects":null,"install_time_s":1.7,"import_time_s":null,"mem_mb":null,"disk_size":null}]}}