Model.deploySQL¶

In [ ]:

Model.deploySQL()

Returns the SQL code needed to deploy the model.

Returns¶

str : the SQL code needed to deploy the model.

Example¶

In [1]:

from verticapy.learn.preprocessing import CountVectorizer
model = CountVectorizer(name = "public.cv_titanic")
model.fit("public.titanic", ["name",])
display(model.deploySQL())

'SELECT * FROM (SELECT token, cnt / SUM(cnt) OVER () AS df, cnt, rnk FROM (SELECT token, COUNT(*) AS cnt, RANK() OVER (ORDER BY COUNT(*) DESC) AS rnk FROM public.cv_titanic GROUP BY 1) VERTICAPY_SUBTABLE) VERTICAPY_SUBTABLE WHERE (df BETWEEN 0.0 AND 1.0)'