Can I Limit the Data I Sync to a Set Number of Rows?

Question

I can limit the data I sync by choosing columns and tables in the Schema tab. Can I limit the data I sync to only a set number of rows instead?

For example, I may only want to sync 500 thousand rows if I have one million rows in total.

Environment

All destinations

Answer

We don't support the ability to limit the amount of data you sync by a set number of rows. We don't apply conditional logic to include or exclude rows during a sync, meaning all rows are eligible. Limiting the amount of data you sync is possible only by including or excluding tables or columns.