Google Data Studio Partner Connector

Introduction

DataChannel offers a no-code, no-maintenance, and fully automated connection between a user-determined data warehouse and Google Data Studio using its pre-built Google Data Studio Connector. It enables seamless conversion of your data into customizable informative reports and dashboards to yield actionable insights in real-time.

ds dc gds main

Google Data Studio

Introduced by Google in 2016, Google Data Studio is a powerful tool for creating interactive dashboards and engaging0 reports. These reports and dashboards interact with the underlying data using different data source connectors. Google Data Studio provides 18+ data connectors for popular data sources such as Bigquery, Google Cloud Storage, MySQL, Google Ads, etc. However, for any other data source, a user has to depend on different partner data connectors individually.

DataChannel & Google Data Studio

Manual ETL and reporting are time-consuming, inefficient, erroneous, and a regular burden on human resources. DataChannel offers 100+ pre-built connectors for data aggregation and replication, in conjunction with a Google Data Studio connector to enable automated regular retrieval of pre-defined datasets in a user-determined data warehouse, which can then be directly used for reporting or dashboards in the Google Data Studio. DataChannel consolidates data that is fragmented, incomplete, in multiple formats, siloed, and has poor inter-linkages into a single source of truth (user-determined data warehouse) which can then assist in setting priorities, evaluating performance, and making decisions.

Prerequisites for connecting your data warehouse to Google Data Studio
  • An active Gmail account to work with Google Data Studio

  • An API access key from the DataChannel Account

  • A Data Warehouse configured in your DataChannel account

Step By Step Guide

Step 1

Log into your DataChannel account and get the API key.

gds getapi1
Step 2

Go to your Data Studio Account and access DataChannel Google Data Studio Connector from the partner connectors. [Create → Data Source or use this link].

gds
Step 3

Use the API Key generated in Step 1 to gain access.

gds2
Step 4

Select a data warehouse from the dropdown menu. [Only data warehouse instances accessible from your DataChannel account are visible here]. In case your data warehouse is not visible, please go to the data warehouse configuration tab in the DataChannel dashboard and check your credentials.

gds3
Step 5

Select the dataset of your choice from the dropdown TableorView. All the tables and views in the chosen data warehouse accessible through DataChannel should be available here. In case a particular dataset is not available, please go to the data warehouse configuration tab in the DataChannel dashboard and check your credentials.

gds4
Step 6

Complete the setup by clicking on CONNECT in the top right corner of the screen. [Detailed instructions in the technical documentation].

gds5

That’s it! You are now free to analyze and report your data.

gds6

Still have Questions?

We’ll be happy to help you with any questions you might have! Send us an email at info@datachannel.co.

Subscribe to our Newsletter for latest updates at DataChannel.