This demo will show you how you can easily use Snowflake Cortex LLM functions for AI-powered text analysis on Iceberg tables. A blog post with step-by-step instructions are available here.
- Run through line 43 of demo.sql in your Snowflake SQL worksheet. External Volume setup instructions can be found here.
- Run through snowpark.ipynb cells, and stop after writing jan_df to the Iceberg table (save_as_table).
- Continue running demo.sql through line 61.
- Setup Snowflake Reader Account, which can be done through the Snowsight UI or with SQL.
- Create a share to the reader account created in step 4, and add the Iceberg table to the share.
- Run all cells in spark.ipynb.