How to querying in Snowflake using Python (SSO Authentication)?

Question

I tried to connect snowflake(SSO Authentication) and get data from table. But, When i run the code, i can login with my credentials in the pop-up browser window and it connect Snowflake, no response after that(the program neither terminate nor provide result). Not sure, where am doing mistake, Pls help.

'''

import snowflake.connector
# Connecting to Snowflake using SAML 2.0-compliant IdP federated authentication
conn = snowflake.connector.connect(
  user='G*****K',
  account='abcdf',
  authenticator='externalbrowser',
  warehouse='abcdf',
  database='abcdf',
  schema='abcdf'
)
cur = conn.cursor()
sql = "select * from abcdf.ACCT limit 10"
x=cur.execute(sql)
cur.close()
print(x) 
'''

Can you try any other command like "Select current_date;"

VTi
– VTi

2020-05-28 12:29:06 +00:00
Commented May 28, 2020 at 12:29 — VTi
– VTi, Commented May 28, 2020 at 12:29

FKayani · Accepted Answer · 2020-05-28 14:04:14Z

1

I believe you are closing the cursor before the print;

    try:
    cur.execute("SELECT col1, col2 FROM test_table ORDER BY col1")
    for (col1, col2) in cur:
        print('{0}, {1}'.format(col1, col2))
    finally:
    cur.close()

Details: https://docs.snowflake.com/en/user-guide/python-connector-example.html#using-cursor-to-fetch-values

answered May 28, 2020 at 14:04

FKayani

9061 gold badge7 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bipin Bhartola · Accepted Answer · 2020-12-30 13:39:10Z

1

Results of the query are stored in cursor. The contents of cursor may then be stored in a local variable.

Also, best practice to close connection in the end.

https://www.psycopg.org/docs/cursor.html

import snowflake.connector
# Connecting to Snowflake using SAML 2.0-compliant IdP federated authentication
conn = snowflake.connector.connect(
  user='G*****K',
  account='abcdf',
  authenticator='externalbrowser',
  warehouse='abcdf',
  database='abcdf',
  schema='abcdf'
)
cur = conn.cursor()
sql = "select * from abcdf.ACCT limit 10"
cur.execute(sql)
print(cur.fetchall())
cur.close()
conn.close()

answered Dec 30, 2020 at 13:39

Bipin Bhartola

111 bronze badge

Collectives™ on Stack Overflow

How to querying in Snowflake using Python (SSO Authentication)?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related