Models in Rill

Rill provides users the option to build various types of models based on different use cases. Take a look through the list of available types of models!

Fundamentals

• Getting Started with Models - What are models and important topics to remember as you create your own.
• Differences between SQL and YAML Models - Compare SQL and YAML models and learn when to use each.
• SQL Models - Transform and prepare your data with a basic SQL file

Data Ingestion

• Source Models - Ingest data from various sources
• Scheduled Refreshes - Schedule your data refresh

Advanced YAML Features

• Incremental Models - Increment your model to avoid large ingestion times
• Partitioned Models - Split your large data into smaller sizes
• Incremental + Partitioned Models - Combine the concepts of Incremental Models and Partitioned Models into a single file
• Staging Models - When data is not directly available to ingest

Environment Management

• Environment Templating - Separate your production and development settings

Performance Optimization

• Optimize your Models - Optimize model performance and data refresh strategies