Supabase ETL - update publications

[danielgrittner]

Hey,
I am testing out Supabase ETL to sync my data to a DWH. If I add a new table that I now also need to sync to my DWH, do I always need to create a new publication? This feels very cumbersome right now.

[mrx-arafat]

No, you can add it to the publication you already have:

alter publication your_publication add table public.your_table;

Then pick Restart pipeline from the pipeline's actions menu. The pipeline only discovers new publication tables when it starts, so it won't pick the table up until then. If you also want the table's existing rows copied, check the Initial sync selection first (docs).

If you'd rather not touch the publication each time, a publication created with for tables in schema public includes new tables in that schema automatically. You still need the restart, though.