/Python/Snowflake python connector error handling

Snowflake python connector error handling

import os
import snowflake.connector
from snowflake.connector.errors import DatabaseError, ProgrammingError

snowflake_account = os.environ['SNOWFLAKE_ACCOUNT']

if __name__ == '__main__':
    try:
        con = snowflake.connector.connect(
            user='bad username',       # <-------- Bad user
            password='bad password',   # <-------- Bad pass
            account=snowflake_account  # <-------- This is correct
        )
    except DatabaseError as db_ex:
        if db_ex.errno == 250001:
            print(f"Invalid username/password, please re-enter username and password...")
            # code for user to re-enter username & pass
        else:
            raise
    except Exception as ex:
        # Log this
        print(f"Some error you don't know how to handle {ex}")
        raise
    else:
        try:
            results = con.cursor().execute("select * from db.schema.table").fetchall()
            print(results)
        except ProgrammingError as db_ex:
            print(f"Programming error: {db_ex}")
            raise
        finally:
            con.close()

Source: stackoverflow.com

Similar codes

30 votes191 views6 answers
List comprehension if else
Python
0 vote170 views1 answer
Webhook logger python
Python
17 votes179 views6 answers
Input in python
Python
31 votes181 views4 answers
Python convert list of strings to list of integers
Python
69 votes189 views3 answers
How to check if character in string python
Python
3 votes217 views1 answer
Jinja2 datetime format
Python
1 vote165 views1 answer
How to make turtle invisible python
Python
0 vote168 views1 answer
Start ipython with any version
Python
1 vote168 views2 answers
Group by dateime pandas
Python
0 vote164 views1 answer
How to capture video in google colab with python
Python