dbt-risingwave 1.5.1

The RisingWave adapter plugin for dbt

dbt-risingwave

A RisingWave adapter plugin for dbt.

RisingWave is a cloud-native streaming database that uses SQL as the interface language. It is designed to reduce the complexity and cost of building real-time applications. https://www.risingwave.com

dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.

Getting started

The package has not been published to PyPI, please install it via git.

1. Install dbt-risingwave

python3 -m pip install dbt-risingwave

2. Get RisingWave running

Please follow this guide to setup a functional RisingWave instance.

3. Configure dbt profile file

The profile file is located in ~/.dbt/profiles.yml. Here's an example of how to use it with RisingWave.

default:
  outputs:
    dev:
      type: risingwave
      host: 127.0.0.1
      user: root
      pass: ""
      dbname: dev
      port: 4566
      schema: public
  target: dev

4. Run dbt debug to check whether configuration is correct.

Current Status

All items below have been tested against the the latest RisingWave daily build verison.

• dbt seed/run/test/docs works.
• Offical example jaffle_shop is tested.
• RisingWave offical example dbt_rw_nexmark is tested.