Explanation
https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

Explanation
Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared:
* Tables
* External tables
* Secure views
* Secure materialized views
* Secure UDFs
Snowflake enables the sharing of databases through shares, which are created by data providers and
"imported" by data consumers.
https://docs.snowflake.com/en/user-guide/data-sharing-intro.html#:~:text=Secure%20Data%20Sharing%20enabl

Explanation
Some aggregate queries are answered thru micro partitions metadata only not requiring any VW spin ups.

Explanation
https://www.phdata.io/blog/how-to-optimize-snowpipe-data-load/#:~:text=Snowpipe%20is%20typically%20use