BigQuery

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

Introduction

The ROX BigQuery Integration enables customers to share live data directly from Google BigQuery to ROX using Analytics Hub. This integration provides secure, governed access to your data without copying or moving it—you retain full control while ROX gains real-time access to your datasets.

Key Benefits

ROX Account Information

Contact your ROX account team to obtain the ROX service account email required for setting up the Analytics Hub exchange.

Setup Instructions

Step 1: Create an Analytics Hub Exchange

1. In the Google Cloud Console, navigate to BigQuery → Analytics Hub
2. Click Create Exchange
3. Select the Project and Region where your dataset lives

Important: The Exchange region must match your dataset's region. Choose the region where the data you want to share is located.

Step 2: Add ROX as a Subscriber

1. In the Exchange configuration, locate the Subscribers section
2. Add the ROX service account (provided by your ROX account team) to the Subscribers list
3. Save the Exchange configuration

Step 3: Create a Listing

1. Click into your newly created Exchange
2. Click Create Listing
3. Select the dataset you want to share with ROX

Note: Only datasets in the same region as the Exchange will appear in the selection list. If your dataset doesn't appear, verify the regions match.

1. Complete the naming and configuration prompts
2. Publish the listing

Step 4: Notify ROX

Once the listing is published, send the following to your ROX account team:

• Your Google Cloud Project ID
• Exchange name and region
• Listing name
• Brief description of shared datasets and their schema

Choosing What to Share

Best Practice: Use Authorized Views when sharing PII or financial data to enforce fine-grained access controls.

Information to Provide to ROX

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

• Your Google Cloud Project ID
• Exchange name and region
• Listing name
• Brief description of shared datasets and their schema

Prerequisites

Technical Considerations

Security and Compliance

• All data sharing respects your existing Google Cloud IAM policies
• ROX can only access datasets explicitly shared via Analytics Hub listings
• Audit logs available in Cloud Logging for all access events

Performance

• Linked datasets provide direct query access with no data movement
• ROX queries run on ROX's BigQuery slots, not yours
• No impact on your project's query performance or quota

Data Freshness

• Real-time — ROX always queries your live data directly
• No replication delay or sync schedules

Troubleshooting