Hi, I am doing a PoC for airbyte with mysql and redshift source. And wanted to know if I am creating a connection for first time and only want to sync partial data. Lets say data of 1 day and not whole table, is there a way to achieve this? Also lets say I run the connection manually can this be achieved to sync only partial data

You can create a view in Mysql and sync the view.

Thank you for suggestion