Inbound shares

Currently inbound shares are not managed by SnowDDL and should be created manually by ACCOUNTADMIN. Setting up inbound shares normally requires some additional steps performed outside of Snowflake. Also, only one DATABASE can be created for each inbound share, which limits env prefix functionality.

Creation of inbound shares and databases are explained in Snowflake documentation.

1. Configure outbound share to target your account. Make sure it is available using SHOW SHARES command.

2. Run CREATE DATABASE <db_name> FROM SHARE <share_name>.

Once the initial configuration is done, you may grant access to objects in share to business roles using one of the following options:

• parameter share_read for IMPORTED PRIVILEGES;

• global_roles for DATABASE ROLE;