Getting Started with Astrato & Supabase

This guide walks through connecting Supabase to Astrato and building a dashboard from scratch using live query.

By the end of this guide, you’ll be able to produce an interactive dashboard that delivers a self-serve analytics experience.

embedded content

---

1. Prerequisites

Before starting, make sure you have:

• An Astrato account

• A Supabase project

• A database with accessible tables (example used: bike_sales)

📺 Watch video segment

---

2. Identify the Data You Want to Analyse

In Supabase:

• Open your project

• Locate the schema and tables you want to use

• Confirm the dataset structure

This tutorial uses a simple sales dataset to build the first dashboard.

📺 Watch video segment

---

3. Create a New Data Source in Astrato

In Astrato:

1. Go to Data Sources

2. Click New Data Source

3. Choose PostgreSQL / Supabase

4. Enter:

   • Host

   • Database

   • Username

   • Password

   • Port

   • SSL mode (if required)

📺 Watch video segment

---

4. Test & Save the Connection

• Click Test connection

• Save when successful

This establishes the live query link between Astrato and Supabase.

---

5. Create a Semantic Layer

After connecting:

1. Select the tables

2. Define:

   • Measures

   • Dimensions

   • Relationships (if multiple tables)

This step prepares the data for self-service analytics.

📺 Watch video segment

---

6. Build a Workbook

1. Create a New Workbook

2. Add charts and KPIs

3. Use the semantic layer fields

The example builds a fully interactive dashboard from zero.

📺 Watch video segment

---

7. Add Visualisations

Typical first visuals:

• KPI cards

• Time-series chart

• Breakdown by category

All queries run live on Supabase.

For extra value, why not add the Custom Report to enable self-serve analytics for users.

📺 Watch video segment

---

8. Interact With the Dashboard

In preview mode, just like published view, you can:

• Filter

• Drill

• Cross-highlight values on charts (brushing)

This works without extracts because of live query.

📺 Watch video segment

9. Publish dashboard

Once you’re happy with your dashboard, to let other users see it, publish the dashboard.

📺 Watch video segment

10. Embed Dashboard

Embed your dashboard into your own product/portal, for customer facing or even public analytics.

📺 Watch video segment

---

You did it 🥳

You now have:

• A live connection to Supabase

• A reusable semantic layer

• A fully interactive Astrato dashboard