How can I share data with users who do not have a Snowflake account?

453 viewsData Sharing and Collaboration
0

How can I share data with users who do not have a Snowflake account?

Daniel Steinhold Asked question August 28, 2023
0

There are two ways to share data with users who do not have a Snowflake account:

  1. Create a reader account: A reader account is a way to share data with users who do not have a Snowflake account. Reader accounts give users read-only access to shared data, without requiring them to become Snowflake customers.
  2. Use a data sharing partner: There are a number of data sharing partners that can help you to share data with users who do not have a Snowflake account. Data sharing partners can provide a variety of services, such as data hosting, data encryption, and data tokenization.

Here are the steps on how to create a reader account:

  1. Sign in to Snowsight.
  2. In the navigation menu, select Data » Private Sharing.
  3. Select Share » Create a Reader Account.
  4. In the Create Reader Account dialog, specify the following information:
    • Username: The username for the reader account.
    • Password: The password for the reader account.
    • Email address: The email address for the reader account.
    • Permissions: The permissions that you want to grant to the reader account.
  5. Click Create.

Once you have created a reader account, the user will be able to access the data that you shared, subject to the permissions that you granted.

Here are some additional things to keep in mind when sharing data with users who do not have a Snowflake account:

  • You can only share data with users who have been granted the ACCOUNTADMIN role or the CREATE ACCOUNT global privilege.
  • You can share data with users in any region.
  • You can revoke access to shared data at any time.

By following these steps, you can easily share data with users who do not have a Snowflake account.

Here are some data sharing partners that you can consider:

  • Fivetran: Fivetran is a data integration platform that can help you to move data from a variety of sources into Snowflake. Fivetran can also help you to share data with users who do not have a Snowflake account.
  • Informatica: Informatica is another data integration platform that can help you to move data from a variety of sources into Snowflake. Informatica can also help you to share data with users who do not have a Snowflake account.
  • Snowflake Data Sharing: Snowflake offers a Data Sharing service that can help you to share data with users who do not have a Snowflake account. Snowflake Data Sharing can provide a variety of services, such as data hosting, data encryption, and data tokenization.

By using a data sharing partner, you can easily share data with users who do not have a Snowflake account.

Daniel Steinhold Changed status to publish August 28, 2023

Maximize Your Data Potential With ITS

Feedback on Q&A