Model SQL
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 rill start
.