page240
327
Unentitled Data Sharing
To remove the need to create a second Snowflake account within the same CSP and
region, you begin by creating a managed account. You then continue by creating the
containers to deliver unentitled objects and a share to your fictitious customer, after
which you expand your delivery for entitled objects to the same fictitious customer.
Let’s get started!
Creating Managed Accounts
Managed accounts (also known as reader accounts) exist within the context of a single
Snowflake account. According to the Snowflake documentation:
“…Enable data consumers to access and query data shared by the pro-
vider of the account, with no setup or usage costs for the consumer, and
no requirements for the consumer to sign a licensing agreement with
Snowflake.”
When sharing a “share” with a second snowflake account, this section is not
required.
Managed accounts use the same credit allocation as the primary account.
Warehouses in the managed account can consume unlimited credits; therefore, a
resource monitor to limit usage should be set up. You can find more information on
resource monitors at
https://docs.snowflake.com/en/sql-reference/sql/create-
resource-monitor
.
Figure 9-6 shows the relationship between Snowflake-supported containers used
to implement data sharing and the tight coupling between a primary account and a
managed account.
Chapter 9
Client expeCtations