{"library":"snowflake-snowpark-python","title":"Snowflake Snowpark Python","type":"library","description":"Snowflake Snowpark for Python provides an intuitive API for querying and processing data in Snowflake using Python. It enables data engineers and data scientists to build scalable data pipelines and machine learning workflows directly within Snowflake, leveraging its elastic, scalable, and secure engine. The library is actively maintained with frequent releases, typically every few weeks, bringing new features, improvements, and bug fixes.","language":"python","status":"active","last_verified":"Tue May 19","install":{"commands":["pip install snowflake-snowpark-python"],"cli":null},"imports":["from snowflake.snowpark import Session","from snowflake.snowpark import functions","from snowflake.snowpark import types","df = session.create_dataframe(...) # DataFrame objects are typically returned by Session methods."],"auth":{"required":false,"env_vars":[]},"links":{"homepage":"https://www.snowflake.com/","github":"https://github.com/snowflakedb/snowpark-python","docs":"https://docs.snowflake.com/en/developer-guide/snowpark/python/index.html","changelog":"https://github.com/snowflakedb/snowpark-python/blob/main/CHANGELOG.md","pypi":"https://pypi.org/project/snowflake-snowpark-python/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null},"quickstart":{"code":"import os\nfrom snowflake.snowpark import Session\nfrom snowflake.snowpark.functions import col\n\n# Establish a Snowpark Session using environment variables\n# Replace with your actual connection parameters, or configure ~/.snowflake/connections.toml\nconnection_parameters = {\n    \"account\": os.environ.get(\"SNOWFLAKE_ACCOUNT\", \"your_account_identifier\"),\n    \"user\": os.environ.get(\"SNOWFLAKE_USER\", \"your_username\"),\n    \"password\": os.environ.get(\"SNOWFLAKE_PASSWORD\", \"your_password\"),\n    \"role\": os.environ.get(\"SNOWFLAKE_ROLE\", \"your_role\"),\n    \"warehouse\": os.environ.get(\"SNOWFLAKE_WAREHOUSE\", \"your_warehouse\"),\n    \"database\": os.environ.get(\"SNOWFLAKE_DATABASE\", \"your_database\"),\n    \"schema\": os.environ.get(\"SNOWFLAKE_SCHEMA\", \"your_schema\"),\n}\n\nsession = Session.builder.configs(connection_parameters).create()\nprint(\"Snowpark Session created successfully.\")\n\n# Create a simple DataFrame\ndata = [(\"Alice\", 1), (\"Bob\", 2), (\"Charlie\", 3)]\ndf = session.create_dataframe(data, schema=[\"name\", \"id\"])\n\n# Perform a simple transformation and show results\ndf.filter(col(\"id\") > 1).show()\n\n# Close the session\nsession.close()\nprint(\"Snowpark Session closed.\")","lang":"python","description":"This quickstart demonstrates how to establish a Snowpark Session, create a DataFrame from local data, perform a basic transformation, and display the results. Connection parameters are loaded from environment variables for secure and flexible setup. Remember to replace placeholder values with your Snowflake account details.","tag":null,"tag_description":null,"last_tested":"2026-04-24","results":[{"runtime":"python:3.10-alpine","exit_code":1},{"runtime":"python:3.10-slim","exit_code":1},{"runtime":"python:3.11-alpine","exit_code":1},{"runtime":"python:3.11-slim","exit_code":1},{"runtime":"python:3.12-alpine","exit_code":1},{"runtime":"python:3.12-slim","exit_code":1},{"runtime":"python:3.13-alpine","exit_code":1},{"runtime":"python:3.13-slim","exit_code":1},{"runtime":"python:3.9-alpine","exit_code":1},{"runtime":"python:3.9-slim","exit_code":1}]},"compatibility":{"tag":"draft","tag_description":"notable install failures or slow imports","last_tested":"2026-05-19","installed_version":"1.51.0","pypi_latest":"1.51.0","is_stale":false,"summary":{"python_range":"3.10–3.9","success_rate":50,"avg_install_s":8.3,"avg_import_s":3.4,"wheel_type":"wheel"},"results":[{"runtime":"python:3.10-alpine","python_version":"3.10","os_libc":"alpine (musl)","variant":"snowflake-snowpark-python","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.10-alpine","python_version":"3.10","os_libc":"alpine (musl)","variant":"snowflake-snowpark-python","exit_code":1,"wheel_type":null,"failure_reason":null,"import_side_effects":null,"install_time_s":null,"import_time_s":null,"mem_mb":null,"disk_size":null},{"runtime":"python:3.10-slim","python_version":"3.10","os_libc":"slim (glibc)","variant":"snowflake-snowpark-python","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":8.8,"import_time_s":2.4,"mem_mb":43.8,"disk_size":"111M"},{"runtime":"python:3.10-slim","python_version":"3.10","os_libc":"slim (glibc)","variant":"snowflake-snowpark-python","exit_code":0,"wheel_type":null,"failure_reason":null,"import_side_effects":null,"install_time_s":null,"import_time_s":2.2,"mem_mb":43.1,"disk_size":"109M"},{"runtime":"python:3.11-alpine","python_version":"3.11","os_libc":"alpine (musl)","variant":"snowflake-snowpark-python","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.11-alpine","python_version":"3.11","os_libc":"alpine (musl)","variant":"snowflake-snowpark-python","exit_code":1,"wheel_type":null,"failure_reason":null,"import_side_effects":null,"install_time_s":null,"import_time_s":null,"mem_mb":null,"disk_size":null},{"runtime":"python:3.11-slim","python_version":"3.11","os_libc":"slim (glibc)","variant":"snowflake-snowpark-python","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":7.8,"import_time_s":3.65,"mem_mb":49,"disk_size":"119M"},{"runtime":"python:3.11-slim","python_version":"3.11","os_libc":"slim (glibc)","variant":"snowflake-snowpark-python","exit_code":0,"wheel_type":null,"failure_reason":null,"import_side_effects":null,"install_time_s":null,"import_time_s":3.45,"mem_mb":48.3,"disk_size":"117M"},{"runtime":"python:3.12-alpine","python_version":"3.12","os_libc":"alpine (musl)","variant":"snowflake-snowpark-python","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.12-alpine","python_version":"3.12","os_libc":"alpine (musl)","variant":"snowflake-snowpark-python","exit_code":1,"wheel_type":null,"failure_reason":null,"import_side_effects":null,"install_time_s":null,"import_time_s":null,"mem_mb":null,"disk_size":null},{"runtime":"python:3.12-slim","python_version":"3.12","os_libc":"slim (glibc)","variant":"snowflake-snowpark-python","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":7.7,"import_time_s":4.33,"mem_mb":48.7,"disk_size":"119M"},{"runtime":"python:3.12-slim","python_version":"3.12","os_libc":"slim (glibc)","variant":"snowflake-snowpark-python","exit_code":0,"wheel_type":null,"failure_reason":null,"import_side_effects":null,"install_time_s":null,"import_time_s":4.87,"mem_mb":48.1,"disk_size":"117M"},{"runtime":"python:3.13-alpine","python_version":"3.13","os_libc":"alpine (musl)","variant":"snowflake-snowpark-python","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-alpine","python_version":"3.13","os_libc":"alpine (musl)","variant":"snowflake-snowpark-python","exit_code":1,"wheel_type":null,"failure_reason":null,"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":"snowflake-snowpark-python","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":7.3,"import_time_s":3.85,"mem_mb":50.5,"disk_size":"118M"},{"runtime":"python:3.13-slim","python_version":"3.13","os_libc":"slim (glibc)","variant":"snowflake-snowpark-python","exit_code":0,"wheel_type":null,"failure_reason":null,"import_side_effects":null,"install_time_s":null,"import_time_s":4.03,"mem_mb":49.8,"disk_size":"117M"},{"runtime":"python:3.9-alpine","python_version":"3.9","os_libc":"alpine (musl)","variant":"snowflake-snowpark-python","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-alpine","python_version":"3.9","os_libc":"alpine (musl)","variant":"snowflake-snowpark-python","exit_code":1,"wheel_type":null,"failure_reason":null,"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":"snowflake-snowpark-python","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"noisy","install_time_s":9.8,"import_time_s":2.7,"mem_mb":43.1,"disk_size":"110M"},{"runtime":"python:3.9-slim","python_version":"3.9","os_libc":"slim (glibc)","variant":"snowflake-snowpark-python","exit_code":0,"wheel_type":null,"failure_reason":null,"import_side_effects":null,"install_time_s":null,"import_time_s":2.48,"mem_mb":42.8,"disk_size":"109M"}]}}