How Do I Migrate SQL Computed Traits to Segment Reverse ETL Syncs? – Twilio Support

Question

What should be considered when migrating enrichment logic from SQL Computed Traits to Reverse ETL in Segment?

Segment

Segment Console

When migrating from SQL Computed Traits to Reverse ETL, consider the following:

Reverse ETL requires write access to create and manage state tables in a dedicated schema in your data warehouse.
Modifying the SQL model’s structure triggers a full re-sync of records to the destination.
By default, null values are synced and may overwrite existing data; disable the “Sync null values” option to preserve existing values.
Data types are set based on the first value processed; explicitly cast columns in SQL queries if strict typing is required.

Do not alter or delete the records or checkpoints tables in the __segment_reverse_etl schema, as they are critical for data integrity.