snowuser = 'username'
snowpass = 'password'
snowacct = 'account'

from snowflake.snowpark import Session

print('connecting..')
cnn_params = {
    "account": snowacct,
    "user": snowuser,
    "password": snowpass,
    "warehouse": "project_warehouse",
    "database": "project_database",
    "schema": "project_schema"
    }
print('session..')
sess = Session.builder.configs(cnn_params).create()
print('test data..')
df = sess.sql("Select current_warehouse(), current_database(), current_schema()").collect()
sess.close()
print('done.')

