Notification

This article is about Looker Studio. For Looker documentation, visit https://cloud.google.com/looker/docs/intro.

Tutorial: Create a BigQuery data source

Use a public BigQuery project to create a Looker Studio data source.

In this lesson, you'll use the data source tool to build a connection to a BigQuery table. You can use the publicly available table described here, or substitute your own table.

BigQuery is a paid product and you will incur BigQuery usage costs when accessing BigQuery through Looker Studio.
To create a BigQuery data source, you'll need to set up a billing project, if you don't already have one.
In this article:

1 Connect to BigQuery

The first step in creating a data source is to connect to your data set.

  1. Sign in to Looker Studio.
  2. On the Looker Studio home page, in the top left, click The Create icon. Create and then select Data Source.
  3. Select the BigQuery connector. The Configuration panel appears.
  4. Select PUBLIC DATASETS.
  5. For the Dataset, select samples.
  6. For the Table, select shakespeare.
  7. Select your Billing Project. 
    The Select Connector panel for a BigQuery connection displays options for Projects, Billing Projects, Data Sets, and the available Tables.
  8. Click CONNECT. The Fields panel appears.
    The fields panel displays the Index, Field name, ID, Type, Aggregation, and Description settings for data source fields.

The fields panel contains all the dimensions (in green) and metrics (in blue) from the data set. You can fine-tune the data source by renaming or disabling fields, changing the data type, and more.

2 Rename your data source

Looker Studio automatically names your data source the same as your data set name. If you want to change that, click the name in the upper left and enter a new name.

You can also rename the data source later from the DATA SOURCES home page by clicking the context menu and selecting Rename.

3 Optional: Share the data source

You can let other editors add this data source to reports by sharing it with them.

To share a data source

  1. In the upper right, click Share icon Share.

  2. Enter the email addresses or Google Groups that you want to share with.

  3. For each person or group, select the access (permissions). Permissions determine what other people can do with the data source. Your choices are as follows:

    • Can view. People with this permission can view but not edit the data source.

    • Can edit. People with this permission can both view and edit the data source.

If you want to let other editors use this data source to create reports, you'll need to share it with them.

There are 2 aspects to sharing data sources:

  • Granting access to the data set (credentials). By default, when you create a data source, Looker Studio uses your credentials to authorize access to the data set. These credentials are stored securely and passed through by the data source to the underlying data set. Other people can then view or create reports that use this data without requiring them to have their own access to the data set.

    You can instead require each user of the data source and any reports built on it to provide their own credentials to the data set. To do this:
    1. Select the CONFIGURATION tab
    2. Change the Data source access to Viewer's Credentials
  • Granting access to the data source (permissions). Permissions determine what other people can do with the data source. Your choices are:
    • Can view. People with this permission can view but not edit the data source.
    • Can edit. People with this permission can both view and edit the data source.

There are some important considerations to keep in mind when sharing data sources and reports. See the Related resources section below for links to more information.

4 Use this data source in reports

The CREATE REPORT button on the edit connection page.

Click Create Report in the upper right.

You can now create reports that get their data from your BigQuery project.

Related resources

Was this helpful?

How can we improve it?
true
Search
Clear search
Close search
Google apps
Main menu