We have a business use case regarding syncing only a sample of connectors in development/Beta environments to test our pipelines, which is crucial at initial setup and for updates as well. In short, we would like to avoid syncing very large tables multiple times (dev/beta/prod), and would like to have the option to sync only a sample for selected connectors in non-prod environments: this could be a simple LIMIT clause too. The idea is to have the tables set up in the different environments – especially new tables within an existing, previously synced connector – so pipelines could start using them without failure (which is the case currently unless we unpause the connector). Even though we have an initial sync from months ago for a given connector, as new tables appear we would need to get those to all environments as well, however, restarting/unpausing the connector is not an option as then all data would be resynced for the other tables too. Finally, we cannot sync only new tables while the connector itself is paused: "If the connector is paused, the table sync will be scheduled to be performed when the connector is re-enabled.".
Please help us with the above issue.