Queries
You can also run PQL queries using the SDK. Any query that you run in the Predibase Query Editor can also be run using our pql_execute()
command. We have even created a handy %%pql
magic tag to allow for easier in cell execution of queries. Most operations possible in the SDK can also be completed via PQL query. The following guide will help showcase that functionality.
Setup
In order to set up your environment for PQL query exectution, you need to execute the following code.
from predibase import pql
%load_ext predibase_notebook
If you want to use PQL cell magic, just add %%pql
to the top of your notebook cell. For example:
%%pql
PREDICT Survived
GIVEN
SELECT *
FROM titanic;