Getting Error streaming data while writing to a temporary file, reason=No space left on device

Using snowflake bulk load to load a big table. Got the error after extracting 43+ Millions rows from source and not inserted any rows in the target table.

I have changed Buffer size from 10MB to 100MB but no luck. I am not sure what other settings need to change to run this pipeline.

Here is the detailed error message.

Snap errors: {ruuid=79122f75-f6ed-4af3-867b-012f2c8e03fa, label=Snowflake - Bulk Load, failure=Error streaming data while writing to a temporary file, reason=No space left on device, resolution=Address the reported issue.}

Got the error after extracting 43+ Millions rows from source and not inserted any rows in the target table.