{"library":"snowflake-core","title":"Snowflake Python API for Resource Management (snowflake-core)","type":"library","description":"The `snowflake-core` library is a Python API that provides programmatic access to Snowflake entity metadata and allows for interaction with Snowflake resources. It enables users to create, delete, and modify Snowflake objects using Python, offering similar functionality to Snowflake's SQL command API. The library is currently at version 1.12.0 and is actively maintained with regular releases.","language":"python","status":"active","last_verified":"Wed May 20","install":{"commands":["pip install snowflake-core"],"cli":null},"imports":["from snowflake.core import Root","from snowflake.connector import connect","from snowflake.snowpark import Session"],"auth":{"required":false,"env_vars":[]},"links":{"homepage":"https://www.snowflake.com","github":null,"docs":null,"changelog":null,"pypi":"https://pypi.org/project/snowflake-core/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null},"quickstart":{"code":"import os\nfrom snowflake.connector import connect\nfrom snowflake.snowpark import Session\nfrom snowflake.core import Root\n\n# Option 1: Create Root instance from Snowflake Connection\nconnection_params = {\n    \"account\": os.environ.get(\"SNOWFLAKE_ACCOUNT\", \"\"),\n    \"user\": os.environ.get(\"SNOWFLAKE_USER\", \"\"),\n    \"password\": os.environ.get(\"SNOWFLAKE_PASSWORD\", \"\"),\n    \"database\": os.environ.get(\"SNOWFLAKE_DATABASE\", \"test_db\"),\n    \"warehouse\": os.environ.get(\"SNOWFLAKE_WAREHOUSE\", \"test_wh\"),\n    \"schema\": os.environ.get(\"SNOWFLAKE_SCHEMA\", \"public\"),\n}\n\n# Ensure required environment variables are set\nif not all(connection_params.values()):\n    print(\"Warning: Some Snowflake connection parameters are missing. Please set SNOWFLAKE_ACCOUNT, SNOWFLAKE_USER, and SNOWFLAKE_PASSWORD environment variables.\")\n    # Exit or handle error if connection is critical\n\ntry:\n    # Using snowflake.connector\n    connection = connect(**connection_params)\n    root_from_conn = Root(connection)\n    print(f\"Root instance created from SnowflakeConnection: {root_from_conn}\")\n\n    # Example: Accessing a database collection\n    # Assuming 'mydatabase' exists or will be created\n    # my_database = root_from_conn.databases[\"MYDATABASE\"]\n    # print(f\"Accessed database: {my_database}\")\n\n    connection.close()\n\n    # Option 2: Create Root instance from Snowpark Session\n    # Ensure required environment variables are set for Snowpark as well if different\n    session = Session.builder.configs(connection_params).create()\n    root_from_session = Root(session)\n    print(f\"Root instance created from Snowpark Session: {root_from_session}\")\n\n    # Example: Accessing a compute pool collection\n    # compute_pools = root_from_session.compute_pools\n    # print(f\"Accessed compute pools collection: {compute_pools}\")\n\n    session.close()\n\nexcept Exception as e:\n    print(f\"An error occurred during quickstart: {e}\")","lang":"python","description":"This quickstart demonstrates how to initialize the `Root` object, which is the entry point for managing Snowflake resources, using either a `snowflake.connector.connect` object or a `snowflake.snowpark.Session` object. It highlights the use of environment variables for secure connection parameter management.","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":null,"tag_description":null,"last_tested":"2026-05-20","installed_version":"1.8.0","pypi_latest":"1.12.0","is_stale":true,"summary":{"python_range":"3.10–3.9","success_rate":50,"avg_install_s":9.6,"avg_import_s":10.17,"wheel_type":"wheel"},"results":[{"runtime":"python:3.10-alpine","python_version":"3.10","os_libc":"alpine (musl)","variant":"snowflake-core","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-core","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-core","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":10.6,"import_time_s":8.44,"mem_mb":69.1,"disk_size":"126M"},{"runtime":"python:3.10-slim","python_version":"3.10","os_libc":"slim (glibc)","variant":"snowflake-core","exit_code":0,"wheel_type":null,"failure_reason":null,"import_side_effects":null,"install_time_s":null,"import_time_s":8.58,"mem_mb":68.8,"disk_size":"124M"},{"runtime":"python:3.11-alpine","python_version":"3.11","os_libc":"alpine (musl)","variant":"snowflake-core","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-core","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-core","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":9.4,"import_time_s":10.96,"mem_mb":77.8,"disk_size":"135M"},{"runtime":"python:3.11-slim","python_version":"3.11","os_libc":"slim (glibc)","variant":"snowflake-core","exit_code":0,"wheel_type":null,"failure_reason":null,"import_side_effects":null,"install_time_s":null,"import_time_s":11.76,"mem_mb":77.5,"disk_size":"134M"},{"runtime":"python:3.12-alpine","python_version":"3.12","os_libc":"alpine (musl)","variant":"snowflake-core","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-core","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-core","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":8.1,"import_time_s":10.85,"mem_mb":76.7,"disk_size":"125M"},{"runtime":"python:3.12-slim","python_version":"3.12","os_libc":"slim (glibc)","variant":"snowflake-core","exit_code":0,"wheel_type":null,"failure_reason":null,"import_side_effects":null,"install_time_s":null,"import_time_s":13.47,"mem_mb":76.4,"disk_size":"124M"},{"runtime":"python:3.13-alpine","python_version":"3.13","os_libc":"alpine (musl)","variant":"snowflake-core","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-core","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-core","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":7.8,"import_time_s":9.74,"mem_mb":77.7,"disk_size":"124M"},{"runtime":"python:3.13-slim","python_version":"3.13","os_libc":"slim (glibc)","variant":"snowflake-core","exit_code":0,"wheel_type":null,"failure_reason":null,"import_side_effects":null,"install_time_s":null,"import_time_s":12.03,"mem_mb":77.4,"disk_size":"123M"},{"runtime":"python:3.9-alpine","python_version":"3.9","os_libc":"alpine (musl)","variant":"snowflake-core","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-core","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-core","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"broken","install_time_s":12.1,"import_time_s":7.61,"mem_mb":60.9,"disk_size":"119M"},{"runtime":"python:3.9-slim","python_version":"3.9","os_libc":"slim (glibc)","variant":"snowflake-core","exit_code":0,"wheel_type":null,"failure_reason":null,"import_side_effects":null,"install_time_s":null,"import_time_s":8.22,"mem_mb":60.6,"disk_size":"118M"}]}}