The original query is given below: SELECT id ,COUNT(A_NO) AS count FROM table1 WHERE date = ‘2022-02-02’ AND p_no IS NOT NULL GROUP BY id; I need to rewrite the above query by not using p_no IS NOT NULL condition in the WHERE clause. So I tried the below 2 queries but they are taking… Read More Need help in rewriting the query

Is there a way to use "pd.read_sql_query" w/ Snowflake? I am trying to read my snowflake query in a pandas dataframe, however I get an "Attribute Error" stating ‘SnowflakeCursor’ object has no attribute ‘shape’ (code below) … Snowflake python connector works. fetch_pandas_all() works. Once I try reading the query as a pandas dataframe, it breaks.… Read More AttributeError: 'SnowflakeCursor' object has no attribute 'shape'