Did you know you can use SQL queries in your Python worksheets in Snowflake? This works as follows:<\/p>\n\n\n\n
dataframe = session.sql( ”’ YOUR SQL QUERY GOES HERE ”’ )<\/p>\n\n\n\n
And voila! Don\u2019t forget to return it in the function in the worksheet if you wish to inspect the resulting dataframe in the results pane.<\/p>\n\n\n\n
I have used this recently in a stored procedure. The goal of the stored procedure was to check if certain categories from Table_A existed in Table_B and if not, send an email detailing the categories that had to be added to Table_B. Very useful stuff.<\/p>\n","protected":false},"excerpt":{"rendered":"
Did you know you can use SQL queries in your Python worksheets in Snowflake? This works as follows: dataframe = session.sql( ”’ YOUR SQL QUERY GOES HERE ”’ ) And voila! Don\u2019t forget to return it in the function in the worksheet if you wish to inspect the resulting dataframe in the results pane. I…<\/p>\n