/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

1 vote255 views1 answer
How to create an array with known length in python
Python
0 vote236 views1 answer
Check if back is pressed python
Python
0 vote255 views1 answer
Pil
Python
30 votes257 views4 answers
How to round a number in python
Python
0 vote275 views1 answer
Else statement python list comprehension
Python
0 vote288 views1 answer
Issue TypeError: ‘numpy.float64’ object cannot be interpreted as an integer
Python
0 vote239 views2 answers
I type nano in python and o get error
Python
3 votes239 views3 answers
Python How To Play Mp3 File
Python
0 vote294 views1 answer
Write a python program to find fibonacci series upto a certain limit using while loop
Python
2 votes254 views1 answer
Add two column values of a datframe into one
Python