import os
from dotenv import load_dotenv
import snowflake.connector

load_dotenv()

conn = snowflake.connector.connect(
    user=os.environ.get("SNOWFLAKE_USER"),
    account=os.environ.get("SNOWFLAKE_ACCOUNT"),
    authenticator="SNOWFLAKE_JWT",
    role=os.environ.get("SNOWFLAKE_ROLE"),
    warehouse=os.environ.get("SNOWFLAKE_WAREHOUSE"),
    database=os.environ.get("SNOWFLAKE_DATABASE"),
    schema=os.environ.get("SNOWFLAKE_SCHEMA"),
    private_key_file="/Users/sduberg/.ssh/snowflake/rsa_key.p8",
    private_key_file_pwd=os.environ.get("SNOWFLAKE_KEY_PASSPHRASE"),
)