AI
Snowflake
AI_CLASSIFY_TEXT
SnowflakeMengklasifikasikan teks ke dalam kategori yang ditentukan.
Tipe hasil:
OBJECT (category dan score)Diperbarui: 6 Jan 2026Syntax
SQL
SNOWFLAKE.CORTEX.CLASSIFY_TEXT(text, categories)Parameter
textVARCHARwajib
Teks untuk diklasifikasikan
categoriesARRAYwajib
Array kategori yang tersedia
Contoh Penggunaan
Classify Support Tickets
SQL
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;
Klasifikasi tiket support otomatis.
Product Categorization
SQL
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;
Auto-categorize products.