Consuming a data transfer in Snowflake

This article will describe how to consume a Bobsled data transfer in Snowflake. This describes the process to access the data delivered to the Bobsled-managed destination.

Prerequisites

• Before consuming a data transfer, a data transfer must be sent to the destination and access must be configured in Bobsled for the identity that is consuming the data.

• The user accepting a Privately Shared Listing must have their first name, last name, and email set in their profile.
  

  

  
  

• User details can also be set using the SQL query:

  ALTER USER USERNAME SET FIRST_NAME = 'John' LAST_NAME = 'Smith' EMAIL = 'john@company.co';

Consuming a data transfer

1. From the Shares list page, click on the share you want to access.

2. Once a data transfer in the share has been completed, select the button Access Data.

Accessing Data via Snowflake UI

1. Log in to Snowsight ↗ with the account that has access to the share

2. On the sidebar, click on Data, and then click on Private Sharing

3. Under "Shared With Me", select the Bobsled share from your list of Privately Shared Listings. A dialog box will appear to create a database to query the share.

4. In the dialog, you may rename the database to your desired name and, from the drop-down menu, grant privileges to roles that need to access it.

TIP:
The "Create Database from Share" step above will prompt you to grant privileges to other roles at the time you create the database. To grant privileges later, visit Granting Privileges on a Shared Database in Snowflake ↗.  

5. Choose the blue button at the bottom of the dialog, Get Data to create the database. To find the database you have created from the share, navigate to your Databases and query like normal.