If you are able to ingest a limited number of rows, the first thing to look at is the Fetch Size property in your processor.
This should help you to ingest the table in chunks of reasonable size.
If this answers the question, consider marking this as an answer
- Dennis Jaheruddin
If this answer helped, please mark it as 'solved' and/or if it is valuable for future readers please apply 'kudos'.