Snowflake: The Definitive Guide, 2nd Edition

Chapter 1. Snowflake Native App Framework

A Note for Early Release Readers

With Early Release ebooks, you get books in their earliest form—the author’s raw and unedited content as they write—so you can take advantage of these technologies long before the official release of these titles.

This will be the 10th chapter of the final book. Please note that the GitHub repo will be made active later on.

If you’d like to be actively involved in reviewing and commenting on this draft, please reach out to the editor at [e-mail].

In Chapter 9, we learned how data sharing in Snowflake can occur between a data provider and consumer via the Snowflake Marketplace.  The data sharing approach is such that the data flows in one direction, from a provider to a consumer.  Native apps extend this model by allowing application code, in addition to data, to be shared from the provider to the consumer.  The type of application code in a native app can include stored procedures, functions, or Snowpark Container Services.  

A native app database is accessed by the consumer within their own Snowflake environment (Figure 1-1) just like a data share which is a database of data shared to a consumer’s Snowflake account.  Security is maintained for both the provider and the consumer using Snowflake’s powerful role based access control (RBAC) model discussed in detail in Chapter 4.  Thus, the only objects an app can access and the only privileges a native app can be given in a consumer’s account ...