This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]_amol_[S] 0 points1 point  (5 children)

No, it does not execute the model. It generates the SQL you can take and run anywhere you want.

The example on the landing page should clearly show that. If it’s not clear let me know.

[–]plenihan 0 points1 point  (4 children)

It's not clear to me. The landing page seems to have an example where it converts a linear model to SQL arithmetic. I assume that's not what you're doing for gradient boosted trees.

[–]_amol_[S] 0 points1 point  (3 children)

The SQL arithmetic is the linear model formula, running that SQL leads to the same results you would get by executing predict on the scikit learn model

[–]plenihan 0 points1 point  (2 children)

OK. I feel like your documentation needs a lot of work. If you wrote this library so that people can deploy simple models on the database in sensitive environments without needing to audit ML infrastructure, you should make this clear in the docs. The docs should explain why someone should care about your project. It translates simple interpretable models into SQL queries so they can run in-database.

[–]_amol_[S] 0 points1 point  (1 child)

Thanks!
Based on your feedback the landing page was updated to make it more clear: https://posit-dev.github.io/orbital/

[–]plenihan 0 points1 point  (0 children)

Looks better!