Loading the Sample Project

Before we can explore Visitran AI, we need a project with data to work with. We'll use the Jaffle Shop sample project — a small e-commerce dataset with customers, orders, and payments.

Already loaded Jaffle Shop?

If you've already loaded the Jaffle Shop Starter project from the No-Code Quick Start Guide, you can skip this page and go directly to The AI Chat Interface.

Create the Jaffle Shop Starter Project

From the project dashboard, click Load Sample Project, then select Jaffle Shop > Starter.

Visitran will automatically:

1. Create a new project with a demo DuckDB database
2. Upload the seed CSV files (customers, orders, payments)
3. Materialize the seed data into raw source tables

Verifying the Project

Once the project loads, you'll see the Jaffle Shop project in your dashboard. Click to open it.

In the IDE, you should see three seed tables in the file explorer:

• raw_customers — Customer names and IDs
• raw_orders — Order records with dates and status
• raw_payments — Payment records with amounts and methods

The Jaffle Shop Database

Here's an overview of the complete transformation database:

Table	Columns	Rows	Description
raw_customers	id, first_name, last_name	100	Customer directory
raw_orders	id, user_id, order_date, status	99	Order history
raw_payments	id, order_id, payment_method, amount	113	Payment records

This dataset is small enough to understand quickly, but rich enough to demonstrate real transformation patterns like joins, aggregations, and customer analytics.

Now that we have data to work with, let's open the AI chat interface.