# Dagster + DuckDB

> Read and write natively to DuckDB from software-defined assets.

Source: https://dagster.io/integrations/dagster-duckdb
Category: Storage

## About this integration

This library provides an integration with the DuckDB database, and allows for an out-of-the-box [I/O Manager](https://docs.dagster.io/guides/build/io-managers) so that you can make DuckDB your storage of choice.

## Installation

```bash
pip install dagster-duckdb
```

## Example

```python
from dagster_duckdb_pandas import DuckDBPandasIOManager
from dagster import Definitions, asset
import pandas as pd

@asset(
    key_prefix=["my_schema"]  # will be used as the schema in duckdb
)
def my_table() -> pd.DataFrame:  # the name of the asset will be the table name
    return pd.DataFrame()

defs = Definitions(
    assets=[my_table],
    resources={"io_manager": DuckDBPandasIOManager(database="my_db.duckdb")}
)
```

## About DuckDB

**DuckDB** is a column-oriented embeddable OLAP database. A typical OLTP relational database like SQLite is row-oriented. In row-oriented database, data is organised physically as consecutive tuples.