How to Use dbt with RisingWave for Streaming Transformations

TL;DR RisingWave has a dedicated dbt adapter called dbt-risingwave. Install it with pip install dbt-risingwave, point your profiles.yml at RisingWave's PostgreSQL-compatible endpoint, and use the mate