Skip to main content

Getting Started: Data Warehouse Integration

Use your NextStage Data in external reporting systems

Written by Matt Miller

The NextStage Data Warehouse Integration lets you access your NextStage Pipeline and CRM data through a Google BigQuery connection. This article describes how to get started.

Requirements

  • Purchase the Data Warehouse Integration Add-On

Overview

  1. A Google Identity to authenticate to your secure Google Cloud Project

  2. Connect to your external reporting system

Authentication: Create a Google Identity

To get started, we will need a way to securely authenticate your systems with the BigQuery project. If you already have a Google Workspace, we recommend creating a group. You can provision access to users by adding users to your newly created group.

Provide the group email address to NextStage support and our Engineering team will configure your dedicated project for you. Once configured, NextStage will provide a Google Project ID, which you will use to access the data.

Verify Access

You can run queries directly from the BigQuery interface by visiting the URL below. **Replace YOUR_NEXTSTAGE_PROJECT with the ID customer service provides you

https://console.cloud.google.com/bigquery?project=YOUR_NEXTSTAGE_PROJECT

You're all set

You're now ready to run queries directly on NextStage data or connect to external systems. For a quick tutorial on how to connect to the Power BI, check out this video.

Coming soon

  • Data dictionary to

Did this answer your question?