How to Connect Google Data Studio

Limitation & Troubleshooting

Limit of Data Records

When sending your data to Google Data Studio, be aware that it has a limit of how much data it can connect at once. If you see the error below in GDS, it usually means that you have too much data in the source you are trying to connect and the connection timeouts due to the size. You can see how much data is in the source by clicking Data Preview (three dots next to the source under Sources) and the total number of records is shown in the top left. If there are more than 100k records, you reached the limit of Google Data Studio.

The solution:

  1. you can either limit the amount of data (it is possible the amount is this huge because of incorrect snapshotting settings)
  2. or connect the data to a data warehouse instead and then to Google Data Studio. One option is to use Google Sheets.

Connecting Google Data Studio

Step 1 - How to Create Google Sheets Data Destination

  1. Sign in to your Dataddo account and click on Destinations at the top of the page. 
  2. Click on Create Destination in the top right corner.
  3. From the list of destinations, choose Google Data Studio. You can type the name of the connector into the search bar to find it faster.
    Data destinations - selection
  4. You will be redirected to the New Flow configuration.

How to Create a New Data Flow

  1. Click on Flows at the top of the page. 
  2. Click on Create Flow in the top right corner.
  3. Click on Add Source and choose, which from your sources you want to connect. You can type the connector's name into the search bar to find it faster.

    You can add more sources or blend two of the sources. Read more about Data Blending here.

  4. Once you select your data source, click on Add Destination. If you continued from the source creation, Google Data Studio has been selected as a destination automatically.

    Vertica- Flow 4

  5. You can Name your flow by typing the name into the top.
  6. You can see a Data Preview to make sure of your configuration.
    Flow - preview
  7. Click on Save flow.

How to Configure the Data Flow

  1. Click on the three dots next to the flow and choose Config.
  2. You need to authorize the connector by clicking on the link and filling in the Dataddo API Key and Dataddo API Endpoint ID.
    Google Data Studio- Flow configuration 2

  3. You can then click on Connect in the top right corner and your data are sent to Google Data Studio. You can close the Configure dashboard window in Dataddo and you are all set.
  4. Click on Save.

Congratulations, your new Data Destination & Flow are ready!


Need assistance?

Feel free to contact us or create a ticket and we will help you with the setup. To speed the process of resolving your ticket, make sure you provide us with sufficient information.