Links

Google Data Studio Integration

This page walks through the Secoda and GDS integration that Secoda supports
Secoda has two methods of integrating with Google Data Studio: retrieving a session cookie and using Google OAuth
NOTE: Using the Google OAuth method does not extract upstream (datasources) and downstream (charts) lineage due to the limitations of the Google Data Studio API
NOTE: The session cookies expire after 12 hours and you need to re-retrieve the cookie each time you wish to run the extraction.

Getting Started with Google OAuth

There are two steps to get started using Google Data Studio with Secoda through Google OAuth:
  1. 1.
    Authorize Secoda for your Organization
  2. 2.
    Connect Google Data Studio to Secoda

Authorize Secoda on Google Admin

  1. 1.
    Sign in to your Google Admin console and navigate to domain wide delegation.
  2. 2.
    In API clients, click Add new.
  3. 3.
    Enter the Client ID: 884425733446-7lao52vmjg9k7hovpgba2qd5b7qeo8l2.apps.googleusercontent.com
  4. 4.
    Enter the following OAuth scopes:
    • https://www.googleapis.com/auth/datastudio
    • https://www.googleapis.com/auth/userinfo.profile
  5. 5.
    Click Authorize.

Connect to Google Data Studio

  1. 1.
    In Secoda, head to the Integrations page and click New integration
  2. 2.
    Select Google Data Studio and click on the OAuth tab
  3. 3.
    Click the Google OAuth 2.0 button and login using your Google account
  4. 4.
    Head to the History tab on the side bar and click Run extraction

Getting Started with Session Cookies

There are two steps to get started using Google Data Studio with Secoda through session cookies:
  1. 1.
    Retrieve a Google Data Studio session cookie
  2. 2.
    Connect Google Data Studio to Secoda
Secoda uses a series of REST APIs that Google Data Studio uses for its platform, which requires a session cookie. To get a session cookie follow these steps:
  1. 1.
    Login to Google Data Studio and open the developer tools by right-clicking and selecting Inspect
Login to Google Data Studio and open the developer tools by right-clicking and selecting Inspect
2. Click on the Network tab and put https://datastudio.google.com in the filter field
3. Refresh the page and you should see some requests populate
4. Click on the getShareableList network request and then navigate to the Headers tab
5. In the Headers tab, scroll down to the Request Headers section and copy the cookie header.

Connect to Google Data Studio

After retrieving the session cookie, you can connect Google Data Studio to Secoda by following these steps:
  1. 1.
    In Secoda, head to the Integrations page and click New integration
  2. 2.
    Select Google Data Studio
  3. 3.
    Paste the cookie into the Cookie text input field and submit
  4. 4.
    Head to the History tab on the side bar and click Run extraction