0025. Simple python program using snowflake_python_connector.py

import snowflake.connector

ctx = snowflake.connector.connect(
    user="dattapadal",
    password="xxxxxxxxx",
    account="qqhdobp-jt74754",
    warehouse="compute_wh",
    database="my_database",
    schema="my_schema",
    role="SYSADMIN",
    session_parameters={
        "TIMEZONE": "UTC",
    },
)

cs = ctx.cursor()
try:
    sql = """select * from LINEITEM  limit 10"""
    cs.execute(sql)
    # one_row = cs.fetchone()
    all_rows = cs.fetchall()
    # print(one_row[0])
    print(all_rows)

finally:
    cs.close()
ctx.close()