AI_CLASSIFY_TEXT

1
SELECT
2
  ticket_text,
3
  SNOWFLAKE.CORTEX.CLASSIFY_TEXT(
4
    ticket_text,
5
    ['Billing', 'Technical Support', 'Account', 'General Inquiry']
6
  ) as classification
7
FROM support_tickets;

1
SELECT
2
  product_description,
3
  SNOWFLAKE.CORTEX.CLASSIFY_TEXT(
4
    product_description,
5
    ['Electronics', 'Clothing', 'Home & Garden', 'Sports', 'Other']
6
  ):category as predicted_category
7
FROM products;