Data Studio connector

You can use Data Studio to visualize the data in your tables and workspaces in the Tables app!

Data Studio is a reporting and dashboarding tool that lets you read data from multiple data sources, such as Sheets, Tables, BigQuery, etc. and create charts and tables and filterable dashboards to share with stakeholders. This is great for use cases like:

  • Create a single dashboard to show charts/reports on separate tables in one view.
  • Blend/combine data from multiple tables to be summarized in one chart/report.
  • Report across data that's store in different products like Sheets, Tables, and BigQuery.

Visualize data with the Data Studio connector

How to connect Data Studio to Tables

You can start off by A) creating a Report and adding the data source along the way, OR B) create a standalone Data Source first.

In Data Studio, their "reports" and "data sources" are separate objects, and a report can pull data from multiple data sources, and multiple reports can reuse the same data source.

A) Create a Report with a Data Source

  1. Sign in to Data Studio.
  2. In the top left, click Create, then select Report.
  3. A new "Untitled report" will be created, and a prompt to "Add data to report" will show up. Search for and select the Tables (by Area 120 by Google) connector.
  4. Continue to configure your data source (see below).

B) Create a standalone Data Source

  1. Sign in to Data Studio.
  2. In the top left, click Create then select Data Source.
  3. Select the Tables (by Area 120 by Google) connector.
  4. Continue to configure your data source (see below).

Configure the data source

  1. If prompted to grant Data Studio access to your account, click AUTHORIZE.
  2. You can select the table to connect to by either pasting a browser URL, or browsing recent workspaces and tables.
  3. Once you've pasted in the URL to the table, or selected the appropriate workspace and table --
    1. If adding a data source within a report: in the bottom right, click ADD.
    2. If adding a standalone data source: in the upper right, click CONNECT.
      1. The data source fields panel appears.
      2. The data source is now connected to your data set.

Warning: connecting to Data Studio will allow you to report on and share the data beyond the original sharing permissions of the table. The data in Data Studio will update depending on the user-configured data freshness setting (Data Studio help center), or can be manually refreshed by the user.

Configure the data source

The data source fields panel is where you configure the data source by renaming fields and adding descriptions, adding calculated fields, and changing data types and aggregations. Learn more about working with data source fields.

Control who sees the data

At the top of the fields panel, you can change the data credentials. Credentials control who can see the data provided by this data source.

OWNER'S CREDENTIALS lets other people view or create reports that use this data without requiring them to have their own access to the data set.

VIEWER'S CREDENTIALS, on the other hand, requires each user of the data source to provide their own credentials to access the data set.

Learn more about data credentials.

Create a new report from the data source

  1. In the upper right, click CREATE REPORT.
    1. The report editor appears.
  2. Click ADD TO REPORT.
    1. This adds the data source to report.
    2. You can now create charts and controls that get their data from this data source.

New to Data Studio?

Take the Create a report tutorial. Or learn more about the report editor.

 


What data is available from Tables?

You can access all data and columns from a table, with the exception of Smart Columns, which are not yet supported in our API or widely available. Below is how Tables column types are mapped to Data Studio data types:

Data Studio data type Tables column types
Boolean Checkbox columns (values are truefalse, or null if no value was entered)
Number Number, Auto ID columns
Date Date, Update time, Create time, Comment time columns
Text

All other column types: text, dropdown, tags, location, checklist, file attachments, lookups, summary, row ID, etc.

Notes:

  • Person values are a comma separated list of email addresses.
  • Checklist values are a comma separated list of only checked items.
  • File attachment values are a comma separated list of attachment urls.
  • Drive attachment values are a comma separated list of Google Drive file IDs.
  • Location values are only the text address, and do not include lat-long coordinates.

 

Notes:

  • When your table schema is changed (columns changed), you may need to refresh it manually (see below).
  • Data Studio has an inherent limit that will only display up to 1 million rows.

Updating Data Studio after table column change

If any columns in the source table are changed (new columns added, columns deleted, or column types changed), you will need to manually refresh the data source definition, which can be done in the Data Studio editor by the data source owner. See this Data Studio help center article for more details.

Report an issue, get help, or request a feature

For questions, feedback, and support, fill out this feedback form and the team will get back to you shortly!

Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false