copying Data from Big Data Table
You want to use a minimally logged inserts. If your temp/scratch database is on the same instance you can simply do.

SELECT * INTO DATABASE.SCHEMA.TargetTable FROM SourceTable;


The above statement create the table in the target database and bulk insert the data.

If you want to copy the data to a different instance you are best off using SSIS.