Use the Supabase connector to import data from a Supabase project into an Algolia index.
After selecting a table or view, the connector synchronizes your index with updates.
Before you begin
You need:
Select a Supabase data source
-
In the Algolia dashboard, select the Supabase connector and click Connect.
-
Enter your Supabase credentials:
- Host
- Transaction pooler port
- Session pooler port
- Database name
- Username
- Password
-
Give your Supabase source a name.
-
Click Create source.
-
After the connection is verified, choose a destination index and set up a synchronization task.
Select an Algolia destination index
Your Supabase data will be stored in an Algolia index.
- Select an existing index or create a new one.
- Provide the secured Algolia API key for that index.
- Name the destination for easy identification.
- Click Create destination.
Create a synchronization task
Tasks define how and when Algolia fetches data from your Supabase source.
-
Choose how to trigger the sync:
- On demand: run the task from the Algolia dashboard or API.
- Scheduled: choose a predefined schedule or enter a cron expression.
-
Choose how you want to update your Algolia index:
- Full reindexing: replaces all records in the index.
- Full record updates: replaces matching records based on the primary database key.
- Partial record updates: updates specified attributes in matching records.
-
Choose the table or view to import and select which columns to include.
-
Choose a primary key from your Supabase table or view to use as the Algolia
objectID.
-
Click Create task.
Create a separate task for each table or view.
Combining several sources in one task merges them into a single index which can cause data conflicts.
Limitations
This connector is subject to the following limitations:
See also
Transform your data with code