IPython magic to use dbt
Project description
DBT-iPy
Run DBT commands inside a IPython session.
Tutorial
You can access the tutorial notebook here
Quickstart Guide
The first thing you'll probably want to do is to run a DBT RPC server in the background. That will let you run queries, compile SQL code among other things:
%dbt rpc <args>
(the args will be passed directly to dbt as command line arguments)
The two most important parameters would be:
--port [port_number]
Passing this parameter will run the DBT RPC on that port. Default is 8580--existing
This will skip creating a new DBT RPC and instead it will connect to an existing one on the specified port
Compiling queries:
The sql query in the cell will be compiled with the DBT RPC server and IPython will output the text::
%%compile_sql
SELECT ...
Running queries:
The sql query in the cell will be run on the DBT RPC server and IPython will output the agate table. Also, it will run its .print_table()
method::
%%run_sql
SELECT ...
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.