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!

What is a Rill project?

• Getting Started with your Rill Project - Understand Rill project structure and configuration

Connect to your Data

• Connectors Overview - Learn about connecting Rill to data sources and OLAP engines
• OLAP Engines - Configure DuckDB, ClickHouse, Druid, or Pinot for analytics
• Data Sources - Connect to S3, GCS, BigQuery, Snowflake, and more
• Configure Local Credentials - Set up credentials for local development
• Dev/Prod Connectors - Separate your production and development data sources

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 the dashboard

Build Integrations with Custom APIs

• Custom APIs Overview - Create HTTP API endpoints to expose your Rill data
• SQL APIs - Query models, tables, and external databases
• Metrics SQL APIs - Query metrics views with automatic security inheritance
• Dynamic Queries & Templating - Add parameters, user attributes, and conditional logic
• Security & Access Control - Multi-tenant APIs with custom attributes on tokens

Project Settings

• Project Configuration - Configure your Rill Project and set default behavior
• 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