hey team, why is

internal staging

recommended for the loading method (snowflake destination). is it simply because its the easiest to get going with? just want to confirm that S3 staging is definitely more efficient?

Internal staging is recommended because the user in this case does not need to maintain AWS/GCS account also (just provide Snowflake credentials)

Daniel https://docs.snowflake.com/en/user-guide/data-load-considerations-stage.html 😃 The option to have internal staging is to improve the old method "standard insert". I don;t think a benchmark as made to see what is faster, or if the internal staging has some limitation like 10Tb.