Keeping costs in check when sharing data with non-Snowflake users
Snowflake allows data to be shared not only with other Snowflake users, but also with non-Snowflake users. When sharing with a non-Snowflake user, a reader account must be created through which non-Snowflake users gain access to the shared data. Because reader accounts share the parent account's compute resources, some limits must be introduced on the reader account to avoid a hefty compute bill.
Through this recipe, you will explore how to limit the compute costs associated with data sharing when data is shared with non-Snowflake customers, and the compute of the data provider is used.
Getting ready
You will need to be connected to your Snowflake instance via the web UI or the SnowSQL client to execute this recipe. We will act as a data provider and create a reader account that can be subsequently used to share data with non-Snowflake users.
Since we will be creating a reader account, which is an account...