Hey,
There is a limitation of lookup activity but my ask is why are you using lookup activity ?
you should use the copy activity with source as SQL and query there:
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
We have requirement to load 2 Million records Using SQL Query with Lookup activity in pipeline, But it was throwing error like The size 4194461 of lookup activity result exceeds the limitation 4194304, Could any one Please help on this
Hey,
There is a limitation of lookup activity but my ask is why are you using lookup activity ?
you should use the copy activity with source as SQL and query there: