0.13.0

Snowflake Integration

Jetbase now supports Snowflake as a first-class database!

📦 Installation

pip install "jetbase[snowflake]"

🔌 Connecting to Snowflake

Set sqlalchemy_url to your snowflake url. There are 2 types of authentication using sqlalchemy_url: username/password and key pair authentication.

Option 1: Username & Password

# jetbase/env.py
sqlalchemy_url = "snowflake://user:password@account/database/schema?warehouse=COMPUTE_WH"

Option 2: Key Pair Authentication

Use a connection string without a password and configure your private key:

# jetbase/env.py
sqlalchemy_url = "snowflake://user@account/database/schema?warehouse=COMPUTE_WH"
export JETBASE_SNOWFLAKE_PRIVATE_KEY=$(cat snowflake_private_key.pem)

Optional: if your key is encrypted

export JETBASE_SNOWFLAKE_PRIVATE_KEY_PASSWORD="your-key-password"

⚙️ New Config Variables

Option	Environment Variable	Description
snowflake_private_key	JETBASE_SNOWFLAKE_PRIVATE_KEY	PEM-encoded private key for key pair auth
snowflake_private_key_password	JETBASE_SNOWFLAKE_PRIVATE_KEY_PASSWORD	Password for encrypted private keys