Prerequisites
Before you begin, make sure you have:- Sequin installed and configured in your environment
- Permission to create tables in your database
Steps
Open the Sequin web console and navigate to the Change Retention tab. Click “Create retention”.Configure source
1
Select the source table
Select the table you want to capture changes from.
2
Configure filters
Optionally, specify which operations to capture (e.g.,
insert
, update
, and/or delete
). You can also add column filters to capture only certain changes.Configure destination
If you’ve created a change event table previously, you can select it from the list. Otherwise, click Create new change event table to create a new table. This will open a modal that guides you through creating the table:1
Choose a retention policy
Choose a retention policy for change messages.If you’re not sure what to choose, we recommend selecting “None” and setting up a retention policy later.
2
Run the DDL commands
Copy the DDL commands from the modal and run them in your database.
3
Create the retention
Give your change retention a name, and click Create.
Verify
Test that changes are being captured correctly:- Connect to your database
- Make a test change to your source table:
- Verify the change was captured into the destination table: