Sharing a table with another Snowflake account

We will share a basic table with another Snowflake account through this recipe by creating a share and assigning the necessary privileges.

Getting ready

You will need to be connected to your Snowflake instance via the web UI or the SnowSQL client to execute this recipe. We will be acting as a data provider and sharing data with another Snowflake account, acting as the data consumer. Therefore, you will need to know the consumer Snowflake account and, more specifically, you will need to know the consumer account name.

Since we will be creating and consuming a share, which is an account level activity, ACCOUNTADMIN-level access is required on the Snowflake account acting as a provider and on the consumer Snowflake account.

How to do it…

We will be creating a table and populating that table with some sample data. We will share that table further in this recipe. The steps are as follows:

1. We will start by creating...