Snowpipe vs Bulk Loading - gablesiak/learning-path GitHub Wiki

Bulk Loading with COPY Command

-enables loading batches of data files available in cloud storage

-relies on user-provided virtual warehouses

Snowpipe

-designed to load small volumes of data

-incrementally makes data available for analysis

-loads data within minutes after files are added

-also uses COPY command, but with additional features that allows automate process

-uses compute resources provided by Snowflake