Snowflake Connector for Python

import snowflake.connector
import os

# Set these environment variables before running, or replace with your actual credentials:
# export SNOWFLAKE_USER="your_username"
# export SNOWFLAKE_PASSWORD="your_password"
# export SNOWFLAKE_ACCOUNT="your_account_identifier" # e.g., 'yourorg-youraccount.us-east-1.aws'
# export SNOWFLAKE_WAREHOUSE="your_warehouse_name"
# export SNOWFLAKE_DATABASE="your_database_name"
# export SNOWFLAKE_SCHEMA="your_schema_name"

conn = None
cur = None

try:
    conn = snowflake.connector.connect(
        user=os.environ.get('SNOWFLAKE_USER', 'dummy_user'),
        password=os.environ.get('SNOWFLAKE_PASSWORD', 'dummy_password'),
        account=os.environ.get('SNOWFLAKE_ACCOUNT', 'dummy_account'),
        warehouse=os.environ.get('SNOWFLAKE_WAREHOUSE', 'dummy_warehouse'),
        database=os.environ.get('SNOWFLAKE_DATABASE', 'dummy_database'),
        schema=os.environ.get('SNOWFLAKE_SCHEMA', 'dummy_schema')
    )

    cur = conn.cursor()
    cur.execute("SELECT current_version()")
    one_row = cur.fetchone()
    print(f"Successfully connected. Snowflake version: {one_row[0]}")

except snowflake.connector.errors.ProgrammingError as e:
    print(f"Snowflake connection or query error: {e}")
    print("Please ensure environment variables (SNOWFLAKE_USER, SNOWFLAKE_PASSWORD, SNOWFLAKE_ACCOUNT, etc.) are correctly set.")
except Exception as e:
    print(f"An unexpected error occurred: {e}")
finally:
    if cur:
        cur.close()
    if conn:
        conn.close()