Hi There, I have a mysql table I wanted to replic...
# ask-community-for-troubleshooting
a
Hi There, I have a mysql table I wanted to replicate onto my data warehouse, would it be possible to limit this to certain number of rows, or by date. Let's say for the past x day/month/year? My use case is I have data dating back from 2013 and I would like to replicate only the past year. I guess I can do this by creating another table that only pulls what I wanted from the main table. Does anyone else have any recommendations?
👀 1
✅ 1
a
Hi @Anton Escalante I suggest you to create a view from your historical table an limit this view to the past time window you want to replicate. Then only select this view as a stream during your connection setup in Airbyte.
✅ 1
a
I see, thanks for the recommendation