dbt-ipy

KO | EN

gitlite — search

#llm #golang #go #android #docker #nodejs #java #awesome #awesome-list #vue #security #mcp #openai #open-source

(★ 15)

IPython magics to work with DBT

dbt-ipy 최신버젼 다운로드

최종 버전 다운로드 (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# dbt-iPy

Run dbt commands inside a IPython session.

## Installation

`pip install dbt-ipy`

## Tutorial

You can access the [tutorial notebook here](https://github.com/jmriego/dbt-ipy/blob/master/tutorial/Tutorial.ipynb)

## Quickstart Guide

#### Load the extension
`%load_ext dbt-ipy`

#### Connect to dbt RPC
The next 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

## Custom magic commands

### 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 ...
```

### Copying to clipboard

It is also possible to copy the last result returned by dbt to the clipboard. If that's a `%%compile_sql` compiled query it will return the SQL text but if it's a `%%run_sql` table, it will transform it to CSV and copy that to the clipboard. You can then paste the contents of the clipboard into a spreadsheet as usual.

```
%dbt_clipboard
```

dbt-ipy

dbt-ipy 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

dbt-ipy

dbt-ipy 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Download README