I work in an organization with multiple divisions, perhaps each one is in a different region and their Snowflake account is set up in a different region. It is not an uncommon need for my division to request a specific data set that another division has in their account. The problem with replication in Snowflake is that you can only replicate a full database object, possibly containing datasets that the provider don't want to share. The provider could create a copy of the database that contains only a copy of the dataset they want to replicate, but that requires the provider to upkeep two datasets, the original and the copy.
In a scenario where the provider, on a separate cloud region, want to share a single table, Snowflake does not seem to have an effective way of executing that. Has anyone had this scenario? What is the most effective way of doing this without making the engineering team go mad?
