TOPICS commands lets you predict the topics of a piece of text given a text column as input.
Only the text column specified will be analysed and for each entry a topic will be associated.
The command will append two columns to the output:
You can read more about
TOPICS and how it works in the tutorial
on Finding Topics.
TOPICS currently works only for English. You can use our
TRANSLATE function to convert from 120 different languages into English.
TOPICS(<column_name> [, min_topic_size=<min_topic_size>])
column_namethe input column name to run the topic analysis on. This must be a text column.
min_topic_sizecan be used to specify columns the minimum size of a topic.
Appends two new columns to the input data set:
Similar to clustering,
topic_id holds an integer value describing what group the row is associated with.
topic_name field holds the name of the group - ie the topic - as a text value.
Predicts the topics of the text in the column
SELECT * FROM reviews TOPICS("Review Text");