Trying to download 10 GB file using an API to a DB

[RamyaPonnada]

Hi All,

I'm using an API that returns a 10GB CSV report which needs to be further pushed into a SQL server database.

I'm facing both latency issues. And Alteryx is suggesting me to use the temp file option in the download tool instead of a string as the content exceeds 255 characters per row.

Is there any efficient way to complete this task? I'm a beginner here appreciate your guidance.

[Qiu]

@RamyaPonnada 

For the pushing back part, maybe we can use a batch macro?