Building Your Data Analytics Pipeline in Rill

Rill provides a comprehensive platform for building end-to-end data analytics solutions. Once you've connected to your source data or connected to your own OLAP database, you can start building with Rill. Don't forget to check out the reference documentation!

Modeling and Last Mile ETL

• Models Overview - Overview of models available in Rill
• 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
• SQL Models - Transform and prepare your data
• Data Refresh - Schedule your data refresh
• YAML Models - Incremental ingestion, data partitions, and more
• Additional Model Templating - Separate your production and development settings
• Performance Optimization - Optimize model performance and data refresh strategies

Define Measures and Dimensions

• What are Metrics Views? - Learn about Metrics Views!
• Underlying Model/Table - Powering your metrics view with a model or table
• Time Series - The backbone of Rill Explore Dashboards, time
• Dimensions - Expand your dimensions capabilities further in your metrics view
• Measures - Aggregate your measures further in your metrics view
• Define Data Access - Define access and row access policies

Build Visualizations

• Dashboards Types - What are the visualization options in Rill, and how are they different?
• Slice-and-Dice Dashboards - Explore and find insights in your data
• Traditional Visualizations - Visualize your data with various chart types
• Canvas Components - See all of our supported components!
• Define Dashboard Access - Set a SQL boolean query that defines access to dashboard

Build Integrations with External Applications

• Custom API - Create custom API endpoints to retrieve data outside of Rill

Project Settings

• rill.yaml - Configure your Rill project defaults
• Structure your Project - Structure folder architecture in Rill
• Use your favorite IDE - Utilize your favorite IDE to build Rill projects
• Debugging Rill Developer - Troubleshoot dashboard access, trace your reconciled resources, and understand project logs