We use Matillion Data Loader to load Marketo data to BigQuery. We have 323000 leads in Marketo. Matillion loaded 150000. When I re-setup the pipeline it loaded 222000. How to load the whole data? (
We don't see these problems with other connectors like Shopify etc.
Hi @KR717101,
You might turn on Auto Debug and set the Debug level to 3. It may give you more information about what is going on. Keep in mind the connectors in Matillion are simply automating the required API calls. This could mean a whole host of things like the Marketo service only allows X api calls per hour or only allows x rows of data returned per hour. I suspect the reason for not getting all the results is due to some restriction on the Marketo side. I would check to see if you can find anything in the logs on that side. I hope this helps you to troubleshoot the problem.
@Bryan thank you!