Build Your First Pipeline

Overview

In this tutorial, you’ll create a pipeline that:

Fetches data from your database
Transforms it with SQL
Runs on a schedule

Time to complete: 15 minutes

Prerequisites

At least one connector set up
One or more tasks created

Step 1: Create Tasks

First, let’s create the tasks our pipeline will use.

Task 1: Fetch Daily Orders

Go to Tasks

Click Tasks → + New Task

Write the Query

SELECT 
    order_id,
    customer_id,
    total_amount,
    created_at
FROM orders
WHERE created_at >= CURRENT_DATE - INTERVAL '1 day'

Save

Name it “Fetch Daily Orders” and save

Task 2: Calculate Summary

Create Another Task

Click Tasks → + New Task

Write the Summary

SELECT 
    COUNT(*) AS order_count,
    SUM(total_amount) AS total_revenue,
    AVG(total_amount) AS avg_order_value
FROM orders
WHERE created_at >= CURRENT_DATE - INTERVAL '1 day'

Save

Name it “Daily Summary” and save

Step 2: Create the Pipeline

Go to Pipelines

Click Pipelines → + New Pipeline

Name It

Call it “Daily Orders Report”

Add First Task

Drag “Fetch Daily Orders” onto the canvas

Add Second Task

Drag “Daily Summary” onto the canvas

Connect Them

Draw a line from the first task to the second

Save

Click Save

Step 3: Test Your Pipeline

Click Run Now
Watch the tasks execute in sequence
Verify both complete successfully (green status)

Step 4: Schedule It

Open Schedule Tab

Click the Schedule tab

Enable Scheduling

Toggle on “Run on schedule”

Set Frequency

Choose “Daily” at 6:00 AM

Save

Click Save

Your pipeline will now run every morning at 6 AM!

What’s Next?

Automate Reports

Send results via email

Pipeline Best Practices

Learn advanced techniques

​Overview

​Prerequisites

​Step 1: Create Tasks

​Task 1: Fetch Daily Orders

​Task 2: Calculate Summary

​Step 2: Create the Pipeline

​Step 3: Test Your Pipeline

​Step 4: Schedule It

​What’s Next?

Automate Reports

Pipeline Best Practices

Overview

Prerequisites

Step 1: Create Tasks

Task 1: Fetch Daily Orders

Task 2: Calculate Summary

Step 2: Create the Pipeline

Step 3: Test Your Pipeline

Step 4: Schedule It

What’s Next?