Secure Direct Data Share

Provider sharing not enabled for all accounts

Provider sharing is enabled by default for most, but not all accounts.

If you encounter errors when attempting to share data with consumers, the feature may not be enabled for your account. To inquire about enabling it, please contact Snowflake Support.

.

Related Topics

• Working with Secure Views

• Secure UDFs

Secure Direct Data Share is an extremely powerful, yet easy-to-use feature. These topics describe the tasks associated with data providers and data consumers.

Next Topics:

• Data Providers
  • Getting Started with Secure Data Sharing
    • Step 1: Create a Share
    • Step 2: Add Objects to the Share by Granting Privileges
    • Step 3: Add One or More Accounts to the Share
    • Example
  • Sharing Data from Multiple Databases
    • Examples
  • Sharing Data Securely Across Regions and Cloud Platforms
    • Data Sharing Considerations
    • Sharing Data With Data Consumers in a Different Region and Cloud Platform
    • Example 1
    • Example 2
  • Working with Shares
    • Data Sharing and Business Critical Accounts
    • Web Interface for Shares
    • DDL for Shares
    • General Data Sharing Considerations and Usage
    • Preparing to Create a Share
    • Creating a Share Using SQL
    • Maintaining Shares Using SQL
  • Using Secure Objects to Control Data Access
    • Using Clustering Keys for Shared Data
    • Sample Setup and Tasks
    • Sample Script
    • Sample Script (for Consumers)
  • Managing Reader Accounts
    • Overview
    • Web Interface for Reader Accounts
    • DDL for Reader Accounts
    • Enabling Other Roles to Create and Manage Reader Accounts
    • Creating and Managing Reader Accounts Using SQL
  • Configuring a Reader Account
    • Task 1: Log into the Reader Account as the Account Administrator
    • Task 2: Create Custom Roles (Optional)
    • Task 3: Create Users
    • Task 4: Create Resource Monitors (Optional)
    • Task 5: Create Virtual Warehouses
    • Task 6: Create a Database from Each Share Shared with the Account
    • Task 7: Grant Privileges on Virtual Warehouses and Databases to Roles
    • Task 8: Invite Users to Log in and Reset Their Passwords
  • Enabling non-ACCOUNTADMIN Roles to Perform Data Sharing Tasks
    • CREATE SHARE Privilege
    • IMPORT SHARE Privilege
  • Enabling Sharing from a Business Critical Account to a non-Business Critical Account
    • Considerations
    • Granting the OVERRIDE SHARE RESTRICTIONS Privilege to Another Role
• Data Consumers
  • General Limitations for Shared Databases
  • Viewing Available Shares
  • Creating a Database from a Share
    • SQL Examples
  • Creating Table Streams on Shared Tables
  • Granting Privileges on a Shared Database
    • Assigning IMPORTED PRIVILEGES to Other Roles
    • SQL Examples
  • Querying a Shared Database