Ah, my favorite type of error: sporadic! A day days we started getting failures when using fetch_pandas_all() against Snowflake. The query was a basic 'SELECT *' against an analytical data set. Here is the trace: Traceback (most recent call last): File "/Users/david/path/test/main.py", line 31, in <module> df = cs.fetch_pandas_all() File "/Users/david/path/.scriptenv/lib/python3.8/site-packages/snowflake/connector/cursor.py", line 978, in fetch_pandas_all... Continue Reading →
Using Snowflake Key Pair Authentication with Tableau Desktop
I have gotten irrationally annoyed at the (admittedly minor) process of connecting directly to Snowflake lately. When I am using my saved Tableau Online Data Sources it is a single click to connect. When I am connecting directly to Snowflake, I need to go login to my password vault, find my account, copy and paste... Continue Reading →