Supabase

How to connect using the Supabase system integration

Introduction to Superbase with Couchdrop

Couchdrop’s native support for inserting data into Superbase through file actions makes it incredibly simple to move data from virtually any source into your data warehouse. You can configure Couchdrop to automatically ingest files and stream their contents directly into Superbase tables. This enables seamless integration of data coming from cloud storage, SFTP/FTP servers, APIs, or inbound webhooks - all with minimal setup.

With this capability, teams can unlock fast and reliable ingestion of structured or semi-structured data without needing to manage ETL infrastructure. Couchdrop handles the heavy lifting of getting data into Superbase so it’s immediately available for analysis.

How Superbase works with Couchdrop

Superbase is configured in Couchdrop as a platform integration. This type of integration does not appear directly as a virtual folder as Couchdrop needs to understand how to translate the data into rows in Superbase.

Instead; Superbase is configured as a connection and then you can use this connection as a file action inside an Transfer Automations or File Actions.

When you configure the file action - you provide details about the data table schema in Superbase and how that maps to the data files being ingested by Couchdrop.

Requirements

To connect to Supabase in Couchdrop you will need:

• A Supabase account, with a table created that you want to upload data into

• Access credentials, such as your project ID and access key

• Your project ID is typically found in the URL in Supabase, if you navigate to your Supabase project, https://supabase.com/dashboard/project/<project-id>

  • In Couchdrop, the Supabase URL field is typically https://<project-id>.supabase.co

  • Your access key can be generated from within your account settings -> access tokens, within Supabase https://supabase.com/dashboard/account/tokens

• A location or inbound method in Couchdrop that you are ingesting data into.

Configuration Steps

1. Log in to Couchdrop and add a new system integration

2. Select Superbase from the list of available integrations

3. Provide the details above

4. Click Add System Integration and follow the wizard

5. Create an automation or file action and select Superbase as the platform type.