Hey all, we have a reverse ETL we’re running from snowflake. We’re importing data using Tables and updated the table it’s syncing from to include more fields. When we did this and updated the sync fields for the ETL it re-synced all of the rows in the table. Is there any way to do something like this (ie update the columns in a table) without re-syncing previously synced rows?

Hey There! 👋 Your message has been received by the RudderStack team. Our standard customer support hours are 9-6 PM EST, but we will forward this request to your Technical Account Manager, and they will get back to you shortly. Please use the thread for any additional comments.

i checked the docs, but couldn’t see anything about editing which fields sync and how that would affect things.

Whenever the columns mapping is changed, RudderStack runs a full sync the next time. https://www.rudderstack.com/docs/sources/reverse-etl/common-settings/sync-modes/#upsert-mode

Is there any way to add columns without changing the mapping?

Unfortunately, there isn’t a way to add new columns without updating the mapping in the reverse ETL source.

ok thanks for letting me know