Data transformations in Rill Developer are powered by DuckDB and their dialect of SQL. Under the hood, data models are created as views in DuckDB.
Please visit the DuckDB documentation for insight into how to write your models.
In your Rill project directory, create a
<model_name>.sql file in the
models directory containing a DuckDB SQL
SELECT statement. Rill will automatically detect and parse the model next time you run