Snowflake

This guide is for Snowflake. See also: BigQuery | Databricks

Introduction

The ROX Data Warehouse Integration enables customers to share live data directly from their Snowflake data warehouse to ROX. Using Snowflake's native sharing capabilities, this integration provides real-time access to your data without copying, moving, or duplicating it—you retain full control while ROX gains secure, governed access.

This guide covers two methods for sharing data with ROX:

• Direct Secure Share — For customers on the same Snowflake region as ROX
• Private Listing with Auto-Fulfillment — For customers on different clouds or regions

Key Benefits

ROX Account Information

Contact your ROX account team to obtain the following details required for setting up the data share:

• Account Locator (e.g., AB12345) — used when adding ROX as a consumer in a Direct Share (Option A)
• Data Sharing Account Identifier (org.account format, e.g., ROXORG.ACCOUNTNAME) — used when adding ROX as a consumer in a Private Listing (Option B)
• Region — confirms whether you need Option A (same region) or Option B (cross-region)

Important: The identifier format differs by method. Direct Shares use the Account Locator, while Private Listings require the full Data Sharing Account Identifier (org.account format).

Which Method Should You Use?

Not sure which region you're on? Run SELECT CURRENT_REGION(); in your Snowflake account, then contact your ROX account team to confirm which method to use.

Prerequisites

Option A: Direct Secure Share (Same Region)

Use this method if your Snowflake account is on the same region as ROX.

Steps

1. Create a Direct Share
   • Navigate to Data sharing → External sharing → Shared by you
   • Click Share → Create a Direct Share
2. Add Objects
   • Select the tables, views, or secure views you want to share with ROX
3. Add ROX as Consumer
   • In the share settings, add the ROX Account Locator provided by your ROX account team
4. Notify ROX
   • Send your ROX contact:
     • Your Snowflake account identifier
     • The share name you created
     • Brief description of shared objects

Note on navigation: These paths reflect the Snowsight UI as of January 2026. If your navigation menu still shows "Data Products," look under Data Products → Private Sharing → Shared by My Account and use Share → Create a Direct Share.

Option B: Private Listing with Auto-Fulfillment (Cross-Region)

Use this method if your Snowflake account is on a different cloud or region than ROX.

Pre-Steps: Enable Cross-Region Auto-Fulfillment

Before creating a cross-region Private Listing, your Snowflake organization must have auto-fulfillment enabled. This is a one-time setup that requires your Org Admin (ORGADMIN role).

Step 1: Verify Your Account Is Part of a Snowflake Organization

Run the following in your Snowflake account:

SELECT CURRENT_ORGANIZATION_NAME();
SELECT CURRENT_ACCOUNT_NAME();

Both should return values. If CURRENT_ORGANIZATION_NAME() returns NULL, contact Snowflake Support to link your account to an organization.

Step 2: Check If Auto-Fulfillment Is Already Enabled

-- Requires ORGADMIN role
USE ROLE ORGADMIN;

SELECT SYSTEM$IS_GLOBAL_DATA_SHARING_ENABLED_FOR_ACCOUNT('<your_account_name>');

Replace <your_account_name> with the value returned by CURRENT_ACCOUNT_NAME() in Step 1.

• If this returns true → Auto-fulfillment is already enabled. Skip to Step 4.
• If this returns false → Continue to Step 3.

Step 3: Enable Auto-Fulfillment for Your Account

-- Requires ORGADMIN role
USE ROLE ORGADMIN;

SELECT SYSTEM$ENABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT('<your_account_name>');

Don't have ORGADMIN access? Contact your Snowflake Organization Administrator. If you're unsure who that is, file a Snowflake Support ticket requesting auto-fulfillment be enabled for your account.

Step 4: Grant Privileges for Listing & Auto-Fulfillment Management

After auto-fulfillment is enabled on the account, ACCOUNTADMIN can manage auto-fulfillment. If you need to delegate to other roles:

-- As ACCOUNTADMIN
USE ROLE ACCOUNTADMIN;

-- Grant auto-fulfillment management
GRANT MANAGE LISTING AUTO FULFILLMENT ON ACCOUNT TO ROLE <your_role>;

-- Grant listing creation (if using a custom role)
GRANT CREATE DATA EXCHANGE LISTING ON ACCOUNT TO ROLE <your_role>;

Step 5: Confirm Everything Is Ready

-- Verify auto-fulfillment is enabled (requires ORGADMIN)
USE ROLE ORGADMIN;
SELECT SYSTEM$IS_GLOBAL_DATA_SHARING_ENABLED_FOR_ACCOUNT('<your_account_name>');
-- Expected: true

-- Verify your region
SELECT CURRENT_REGION();

-- Get your full account identifier (you'll provide this to ROX)
SELECT CURRENT_ORGANIZATION_NAME() || '.' || CURRENT_ACCOUNT_NAME();

Tip: Save your full account identifier from the last query — you'll need it when notifying ROX after setup.

Steps

1. Start a Private Listing

   • Navigate to Data sharing → External sharing → Shared by you
   • Click Share → Publish to Specified Consumers

   Alternate path: Navigate to Marketplace → Provider Studio, then click Create listing (top right) and select Specified Consumers.

2. Attach Data Product

   • Select + Select to choose the database objects to attach to the listing
   • Add a title and description to help ROX identify the data

3. Add ROX as Consumer

   • In the Who can access section, click + Add
   • Enter the ROX Data Sharing Account Identifier (org_name.account_name format) provided by your ROX account team
   • Snowflake will automatically detect cross-region and enable Auto-Fulfillment

4. Configure Refresh Frequency

   • Set refresh interval (recommended: every 1–2 hours for operational data)
   • Select a warehouse to use for auto-fulfillment
   • Snowflake uses SUB_DATABASE auto-fulfillment by default, which replicates only the objects in your share — not the entire database

5. Publish & Notify ROX

   • Click Publish to make the listing live
   • Send your ROX contact:
     • Your Snowflake account identifier
     • Listing name and share name
     • Refresh frequency configured

First time creating a listing? You'll be prompted to accept the Snowflake Provider Terms of Service and the Customer-Controlled Data Sharing Functionality Terms.

Note on navigation: These paths reflect the Snowsight UI as of January 2026. If your navigation menu still shows "Data Products," look under Data Products → Private Sharing and use Share → Publish to Specified Consumers.

Choosing What to Share

Best Practice: Use Secure Views when sharing PII, financial data, or when you don't want ROX to see the underlying query logic or table structure.

Important for Cross-Region (Option B): If your secure views use policies that reference account-level roles (e.g., using INVOKER_ROLE context function), be aware that auto-fulfillment does not replicate account-level roles. Use database roles with IS_DATABASE_ROLE_IN_SESSION instead. See Snowflake documentation on auto-fulfillment objects for details.

Information to Provide to ROX

After setting up the share, send the following to your ROX account team:

• Your Snowflake Account Locator and Data Sharing Account Identifier (org_name.account_name format)
• Listing name (if using Private Listing) and Share name
• Brief description of shared objects and their schema
• Refresh frequency (if using Private Listing with Auto-Fulfillment)

Technical Considerations

Security and Compliance

• All data sharing respects your existing Snowflake RBAC policies
• ROX can only access objects explicitly granted to the share
• Audit logs available in Snowflake's SNOWFLAKE.ACCOUNT_USAGE schema

Performance

• Zero-copy sharing means no impact on your warehouse compute
• ROX queries run on ROX's compute resources, not yours
• For Private Listings, Auto-Fulfillment replication is incremental and optimized

Data Freshness

Cross-Region Costs (Option B Only)

When using Private Listings with Auto-Fulfillment, the following costs apply:

Initial replication may take longer for large datasets. Subsequent syncs are incremental — only changed data is transferred.

Troubleshooting