Install

pip install ppextensions

Try ppextensions magics

%load_ext ppextensions.ppmagics

Try help to see all the available magics and options

%help
Magic Usage Explanation
hive %hive? Connects to hive engine. Hive magic also gives options to insert csv/dataframe to teradata and publishing data to tableau.
teradata %teradata? Connects to teradata engine. Teradata magic also gives has to insert csv/dataframe to teradata and publishing data to tableau.
presto %presto? Connects to presto engine. Presto magic also has options to publishing data to tableau.
Spark Thrift Server %sts? Connects to Spark Thrift Server. Sts magic also has options to publishing data to tableau.
CSV %csv? Runs sqls on top of csv files. CSV magic also has options to publishing data to tableau.
run %run? Runs a notebook from another notebook. Allows for running parameterized notebooks.
run_pipeline %run_pipeline? Run notebooks sequentially in a stateful Pipeline.

For more info: Github Link