{"library":"snowflake-sqlalchemy","title":"Snowflake SQLAlchemy Dialect","type":"library","description":"The Snowflake SQLAlchemy Dialect is a Python library that provides a SQLAlchemy dialect for connecting to Snowflake data warehouses. It functions as a bridge between SQLAlchemy applications and the Snowflake Connector for Python. The library is actively maintained with frequent releases, often multiple times per quarter, to introduce new features, improve compatibility, and address bug fixes.","language":"python","status":"active","last_verified":"Tue May 19","install":{"commands":["pip install snowflake-sqlalchemy"],"cli":null},"imports":["from sqlalchemy import create_engine","from snowflake.sqlalchemy import URL"],"auth":{"required":false,"env_vars":[]},"links":{"homepage":"https://www.snowflake.com/","github":"https://github.com/snowflakedb/snowflake-sqlalchemy","docs":"https://docs.snowflake.com/en/user-guide/sqlalchemy.html","changelog":"https://github.com/snowflakedb/snowflake-sqlalchemy/blob/main/DESCRIPTION.md","pypi":"https://pypi.org/project/snowflake-sqlalchemy/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null},"quickstart":{"code":"import os\nfrom sqlalchemy import create_engine, text\nfrom snowflake.sqlalchemy import URL\n\n# Replace with your Snowflake credentials or set them as environment variables\nSNOWFLAKE_ACCOUNT = os.environ.get('SNOWFLAKE_ACCOUNT', 'your_account_identifier')\nSNOWFLAKE_USER = os.environ.get('SNOWFLAKE_USER', 'your_user_login_name')\nSNOWFLAKE_PASSWORD = os.environ.get('SNOWFLAKE_PASSWORD', 'your_password')\nSNOWFLAKE_WAREHOUSE = os.environ.get('SNOWFLAKE_WAREHOUSE', 'your_warehouse')\nSNOWFLAKE_DATABASE = os.environ.get('SNOWFLAKE_DATABASE', 'your_database')\nSNOWFLAKE_SCHEMA = os.environ.get('SNOWFLAKE_SCHEMA', 'your_schema')\n\ntry:\n    engine = create_engine(\n        URL(\n            account=SNOWFLAKE_ACCOUNT,\n            user=SNOWFLAKE_USER,\n            password=SNOWFLAKE_PASSWORD,\n            database=SNOWFLAKE_DATABASE,\n            schema=SNOWFLAKE_SCHEMA,\n            warehouse=SNOWFLAKE_WAREHOUSE\n        )\n    )\n\n    with engine.connect() as connection:\n        result = connection.execute(text('SELECT current_version()')).fetchone()\n        print(f\"Connected to Snowflake. Current version: {result[0]}\")\n\nexcept Exception as e:\n    print(f\"Error connecting to Snowflake: {e}\")\nfinally:\n    if 'engine' in locals():\n        engine.dispose() # Ensures all connections are closed.","lang":"python","description":"This quickstart demonstrates how to establish a connection to Snowflake using `create_engine` with the `snowflake.sqlalchemy.URL` object. It then executes a simple query to retrieve the current Snowflake version. Remember to replace placeholder credentials with your actual Snowflake account details or set them as environment variables. It's crucial to properly close the connection and dispose of the engine.","tag":"draft","tag_description":"notable failures across runtimes","last_tested":"2026-04-24","results":[{"runtime":"python:3.10-alpine","exit_code":1},{"runtime":"python:3.10-slim","exit_code":0},{"runtime":"python:3.11-alpine","exit_code":1},{"runtime":"python:3.11-slim","exit_code":0},{"runtime":"python:3.12-alpine","exit_code":1},{"runtime":"python:3.12-slim","exit_code":0},{"runtime":"python:3.13-alpine","exit_code":1},{"runtime":"python:3.13-slim","exit_code":0},{"runtime":"python:3.9-alpine","exit_code":1},{"runtime":"python:3.9-slim","exit_code":0}]},"compatibility":{"tag":"draft","tag_description":"notable install failures or slow imports","last_tested":"2026-05-19","installed_version":"1.9.0","pypi_latest":"1.9.0","is_stale":false,"summary":{"python_range":"3.10–3.9","success_rate":50,"avg_install_s":8.7,"avg_import_s":0.64,"wheel_type":"wheel"},"results":[{"runtime":"python:3.10-alpine","python_version":"3.10","os_libc":"alpine (musl)","variant":"snowflake-sqlalchemy","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-sqlalchemy","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-sqlalchemy","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-sqlalchemy","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":null,"install_time_s":9.4,"import_time_s":0.37,"mem_mb":15.5,"disk_size":"113M"},{"runtime":"python:3.10-slim","python_version":"3.10","os_libc":"slim (glibc)","variant":"snowflake-sqlalchemy","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":9.1,"import_time_s":0.37,"mem_mb":15.5,"disk_size":"113M"},{"runtime":"python:3.10-slim","python_version":"3.10","os_libc":"slim (glibc)","variant":"snowflake-sqlalchemy","exit_code":0,"wheel_type":null,"failure_reason":null,"import_side_effects":null,"install_time_s":null,"import_time_s":0.37,"mem_mb":15.5,"disk_size":"111M"},{"runtime":"python:3.11-alpine","python_version":"3.11","os_libc":"alpine (musl)","variant":"snowflake-sqlalchemy","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-sqlalchemy","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-sqlalchemy","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-sqlalchemy","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":null,"install_time_s":8.4,"import_time_s":0.67,"mem_mb":17.6,"disk_size":"122M"},{"runtime":"python:3.11-slim","python_version":"3.11","os_libc":"slim (glibc)","variant":"snowflake-sqlalchemy","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":8.7,"import_time_s":0.68,"mem_mb":17.6,"disk_size":"122M"},{"runtime":"python:3.11-slim","python_version":"3.11","os_libc":"slim (glibc)","variant":"snowflake-sqlalchemy","exit_code":0,"wheel_type":null,"failure_reason":null,"import_side_effects":null,"install_time_s":null,"import_time_s":0.64,"mem_mb":17.6,"disk_size":"120M"},{"runtime":"python:3.12-alpine","python_version":"3.12","os_libc":"alpine (musl)","variant":"snowflake-sqlalchemy","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-sqlalchemy","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-sqlalchemy","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-sqlalchemy","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":null,"install_time_s":7.4,"import_time_s":0.91,"mem_mb":17.4,"disk_size":"112M"},{"runtime":"python:3.12-slim","python_version":"3.12","os_libc":"slim (glibc)","variant":"snowflake-sqlalchemy","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":7.5,"import_time_s":0.81,"mem_mb":17.4,"disk_size":"112M"},{"runtime":"python:3.12-slim","python_version":"3.12","os_libc":"slim (glibc)","variant":"snowflake-sqlalchemy","exit_code":0,"wheel_type":null,"failure_reason":null,"import_side_effects":null,"install_time_s":null,"import_time_s":0.88,"mem_mb":17.4,"disk_size":"111M"},{"runtime":"python:3.13-alpine","python_version":"3.13","os_libc":"alpine (musl)","variant":"snowflake-sqlalchemy","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-sqlalchemy","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-sqlalchemy","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-sqlalchemy","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":null,"install_time_s":7.2,"import_time_s":0.76,"mem_mb":17.6,"disk_size":"112M"},{"runtime":"python:3.13-slim","python_version":"3.13","os_libc":"slim (glibc)","variant":"snowflake-sqlalchemy","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":7.1,"import_time_s":0.77,"mem_mb":17.6,"disk_size":"112M"},{"runtime":"python:3.13-slim","python_version":"3.13","os_libc":"slim (glibc)","variant":"snowflake-sqlalchemy","exit_code":0,"wheel_type":null,"failure_reason":null,"import_side_effects":null,"install_time_s":null,"import_time_s":1.05,"mem_mb":17.6,"disk_size":"110M"},{"runtime":"python:3.9-alpine","python_version":"3.9","os_libc":"alpine (musl)","variant":"snowflake-sqlalchemy","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-sqlalchemy","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-sqlalchemy","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-sqlalchemy","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":null,"install_time_s":11.2,"import_time_s":0.44,"mem_mb":15.1,"disk_size":"112M"},{"runtime":"python:3.9-slim","python_version":"3.9","os_libc":"slim (glibc)","variant":"snowflake-sqlalchemy","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":10.7,"import_time_s":0.44,"mem_mb":15.1,"disk_size":"112M"},{"runtime":"python:3.9-slim","python_version":"3.9","os_libc":"slim (glibc)","variant":"snowflake-sqlalchemy","exit_code":0,"wheel_type":null,"failure_reason":null,"import_side_effects":null,"install_time_s":null,"import_time_s":0.4,"mem_mb":15.1,"disk_size":"111M"}]}}