Max File size from for Automating Snowpipe for Amazon S3

See how pipe performs for your data, in theory it's made for 'this' but if your just getting daily 10gig dumps it might be a bit over kill and take a long time to load and be more complicated than a standard scheduled copy command to restate data if whoever is sending this data isn't perfect.

Depending on workload you could just leave the data where it's at and do external tables. Currently my company has a couple of these with multiple TB of data in S3 buckets.

Basically double check what the needs are and if you need the performance of native tables before spending the money loading data 😉