page275
363
Managed (or Reader) Accounts
Managed accounts enable providers to share data with non-Snowflake customers as
they are created, managed, and owned by the provider account. In addition to creating
managed accounts for our client use, managed accounts are also useful for local testing.
You can find more information on managed accounts at
https://docs.snowflake.com/
en/user-guide/data-sharing-reader-create
.
Figure 10-2 shows the relationship between Snowflake-supported containers used
to implement data sharing. Note the tight coupling between a primary account and a
managed account.
Figure 10-2.
Managed account in context
Managed accounts use the same credit allocation as the creating primary account.
Provisioning managed accounts may lead to uncontrolled credit consumption. If
managed accounts are provisioned, warehouses in the managed account can consume
unlimited credits from the providers budget; 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
.
I do not advise the creation of managed accounts but instead prefer each client to
develop their own relationship with Snowflake Inc. However, managed accounts can
be useful when testing shares as this approach removes the need to spin up a second
Snowflake account.
ChapTer 10
OpTimizing perfOrmanCe