Скачать или смотреть Snowflake Secure Data Sharing - Sharing Data from Multiple Databases | Rajiv Gupta Learn Everyday

Snowflake data providers can share data that resides in different databases by using secure views. A secure view can reference objects such as schemas, tables, and other views from one or more databases, as long as these databases belong to the same account.

The process of sharing a secure view that references objects from multiple databases is slightly different from sharing data residing in a single database.

In addition to performing all the standard steps to share data, you must grant the REFERENCE_USAGE privilege on each database referenced by a secure view you wish to share. However, you do not need to grant REFERENCE_USAGE on the database where the secure view is created.

You must grant the privilege separately on each database referenced in a view, before adding the view to a share (i.e. granting SELECT on the view to a share).