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.