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 ROX Snowflake account identifier, account locator, and region details required for setting up the data share.

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.

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 Secure Share
   • Navigate to Data Products → Private Sharing → Shared by My Account
   • Click Share → Create a Secure 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 identifier 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

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.

Steps

1. Create a Secure Share
   • Navigate to Data Products → Private Sharing → Shared by My Account
   • Click Share → Create a Secure Share
   • Add the tables, views, or secure views you want to share
2. Create a Private Listing
   • Navigate to Data Products → Provider Studio → Listings
   • Click + Listing
   • Select Only Specified Consumers
3. Attach Data Product
   • Link your Secure Share to the listing
   • Add a title and description to help ROX identify the data
4. Add ROX as Consumer
   • In the Who can access section, click + Add
   • Enter the ROX account identifier provided by your ROX account team
   • Snowflake will automatically detect cross-region and enable Auto-Fulfillment
5. Configure Refresh Frequency
   • Set refresh interval (recommended: every 1-2 hours for operational data)
   • Select a warehouse to use for auto-fulfillment
6. 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.

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.

Information to Provide to ROX

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

• Your Snowflake Account Identifier (org.account 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)

Prerequisites

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

Troubleshooting