Supabase

Supabase offers the best of both worlds in terms of allowing you to have both storage buckets and Postgres SQL tables. Both coexist within the same platform, making development a breeze.

Setup

1. Create a storage bucket with an appropriate name (e.g. terra-payloads) in your project

2. Create a table within your project. You do not need to add columns to it, Terra will handle that when connecting to it.

3. Create an API key for access to your supabase project. Terra will need read & write access to the previously created resources in steps 1 and 2.

You'll then need to enter the above details (host, bucket name, and API key) into your Terra Dashboard when adding the Supabase destination

Data Structure

When using Supabase (since you get the best of SQL and S3 buckets 🎉) Terra stores the data in the same structure as for SQL and for S3 Buckets. Follow those sections for more detailed information on how that is stored!