Skip to main content

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;

Functions

pql.set_verbose

pql.get_connections

pql.set_connection

pql.execute