To easily transfer data from a production account to a non-production account in Snowflake within the same cloud provider region, creating a data share is the most efficient approach. Data sharing allows for live, read-only access to selected data objects from the production account to the non-production account without the need to duplicate or move the actual data. This method facilitates seamless access to the data for development, testing, or analytics purposes in the non-production environment.
References:
Snowflake Documentation: Data Sharing

Snowflake's Data Exchange feature provides a data hub for secure data collaboration. It allows providers to publish data that can be discovered and accessed by a selectedgroup of invited members, facilitating secure and controlled data sharing within a collaborative environment3. References: [COF-C03] SnowPro Core Certification Exam Study Guide

The Enterprise edition of Snowflake allows for a dedicated metadata store, providing additional features designed for large-scale enterprises Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html

Managed Access Schemas: These are a special type of schema designed for fine-grained access control in Snowflake.
Roles with Grant Authority:
ACCOUNTADMIN:The top-level administrative role can grant object privileges on all objects within the account, including managed access schemas.
SECURITYADMIN:Can grant and revoke privileges on objects within the account, including managed access schemas.
Important Note: The ORGADMIN role focuses on organization-level management, not object access control.