How to Connect Looker Studio to BigQuery

So, you have a massive amount of data stored in Google BigQuery, and you need to build a dynamic, shareable dashboard to make sense of it all. This is where connecting BigQuery to Looker Studio (formerly Google Data Studio) becomes a game-changer. This article will walk you through exactly how to connect the two, step-by-step, and share some practical tips for a smooth setup.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Connect Looker Studio to BigQuery?

Before we jump into the "how," let's quickly cover the "why." Connecting Looker Studio directly to BigQuery gives you a powerful, scalable, and cost-effective way to visualize your data. It’s the perfect pair for a few key reasons:

• Analyze Massive Datasets: BigQuery is designed to handle terabytes of data with incredible speed. Looker Studio lets you visualize the results of those queries without having to import or move the raw data, preventing performance lags.
• Centralized Data Hub: If you're already using BigQuery as your central data warehouse (pulling in data from Google Analytics 4, CRMs, ad platforms, etc.), this connection allows you to create a single source of truth for all your reporting.
• Live Data Access: Once connected, you can set your reports to pull live data directly from BigQuery. This means your dashboards are always up-to-date without any manual exporting or refreshing on your part.
• Cost Efficiency: You only pay for the queries BigQuery runs when your Looker Studio report is loaded or refreshed, rather than paying for constant data storage in a separate analytics platform.

Prerequisites: What You’ll Need Before You Start

Getting a few things in order upfront will make the connection process much smoother. Think of this as your pre-flight checklist. Make sure you have:

• A Google Account: This is a must, as it’s the key to accessing all Google Cloud and Marketing Platform products, including Looker Studio and BigQuery.
• A Google Cloud Platform (GCP) Project: BigQuery lives inside a GCP project. You'll need access to an existing project or have permission to create a new one.
• Your Data in a BigQuery Table: This guide assumes your data is already loaded into a BigQuery table. If not, you’ll need to do that first by uploading files, streaming data, or connecting a federated data source.
• The Right Permissions: This is the most common place people get stuck. Your Google account will need specific Identity and Access Management (IAM) permissions within your GCP project to let Looker Studio see and query your data. At a minimum, you'll need:
• Access to Looker Studio: Finally, you’ll need to be logged into Looker Studio at https://lookerstudio.google.com/.

Step-by-Step Guide: Connecting Looker Studio to Your BigQuery Data

Once your prerequisites are sorted, the actual connection is straightforward. Let’s walk through it together.

Step 1: Create a New Data Source in Looker Studio

Log in to Looker Studio. From the main dashboard, click the + Create button in the top left and select Data Source from the dropdown menu.

You’ll see a list of available connectors. These are divided into two sections: Google Connectors and Partner Connectors.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: Select the BigQuery Connector

Under the "Google Connectors" section, find and click on BigQuery. It’s usually one of the top options.

The first time you do this, Google will require you to authorize Looker Studio to access your Google Cloud projects and BigQuery data. Click the blue AUTHORIZE button and follow the pop-up prompts to give it access.

Step 3: Navigate to Your Project and Select Your Data

After authorization, you’ll see a three-panel navigation view that lets you drill down to your specific data table. This is where you’ll pinpoint the exact data you want to visualize.

• Panel 1 (My Projects): First, select the GCP project that contains your BigQuery data. You might also see tabs for Shared Projects and Public Projects, which are useful for accessing public datasets like Google Trends or cryptocurrency data.
• Panel 2 (Datasets): Once you've selected a project, this panel will populate with all the available datasets within that project. Select the correct dataset.
• Panel 3 (Tables): Finally, choose the specific table you want to connect to. Looker Studio also allows connections to BigQuery Views, so those will appear here as well.

Step 4: Connect Using a Table or Custom Query

At this stage, you also have the option to use a Custom Query instead of selecting a table directly. This is a powerful feature for more advanced use cases.

• Best for Beginners (Connecting a Table): For most users, simply selecting your project, dataset, and table is the easiest and most direct method. Continue with this if you're not comfortable writing SQL.
• Best for Advanced Users (Custom Query): If you need to pre-process your data — for example, by joining multiple tables, unnesting an array, or calculating new fields — you can select the CUSTOM QUERY option. Here, you can write and execute your own SQL query.

Here's a simple custom SQL query example:

SELECT
  transaction_date,
  product_name,
  SUM(quantity_sold) AS total_sold,
  SUM(revenue) AS total_revenue
FROM
  `your-project-id.your_dataset.sales_table`
WHERE transaction_date >= "2023-01-01"
GROUP BY
  1, 2

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 5: Configure Your Data Source Fields

After selecting your table or entering a custom query, click the blue CONNECT button in the top right.

Looker Studio will now present you with the data source configuration screen. This is where it reads the schema of your BigQuery table — all your columns — and automatically assigns a field type (e.g., Number, Text, Date, Boolean), an aggregation method (Sum, Count, Average), and classifies it as either a dimension (green fields) or a metric (blue fields).

While Looker Studio is pretty smart, it's a good idea to review this list. Make sure date fields are correctly identified as Date or Date & Time, and that geographic fields (like Country or City) are properly set. You can also rename fields here for more human-readable titles on your charts.

Step 6: Create Your First Report

Once you’re happy with the field configuration, click Create Report in the top right. A new, blank report canvas will open. Your BigQuery data is officially connected and ready for you to start dragging and dropping fields to build charts and tables.

Common Issues and Quick Fixes

Sometimes you run into a hiccup. Here are a few common issues and how to troubleshoot them.

1. Authorization or Permission Errors

The Problem: You get an "Access Denied" or "Authorization Failed" error when trying to connect or add a chart to your report.

The Fix: This is nearly always a permissions problem in Google Cloud. Go back to your GCP project and double-check your IAM roles. Ensure the account you’re logged into Looker Studio with has, at a minimum, the "BigQuery Data Viewer" and "BigQuery Job User" roles assigned for that project. It might take a minute or two for permission changes to propagate.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

2. Slow Dashboard Performance

The Problem: Your dashboards take a long time to load or update.

The Fix: This happens because every chart on your dashboard sends a new query to BigQuery. There are several ways to fix this:

• Extract Your Data: For data that doesn't change frequently, use Looker Studio's 'Extract' feature. This takes a snapshot of your BigQuery data and stores it within Looker Studio, making reports much faster. You can find this in the Data Source settings.
• Optimize Your BigQuery Tables: Use partitioned and clustered tables in BigQuery, especially for large datasets. This drastically reduces the amount of data BigQuery has to scan for each query, lowering both your costs and load times.
• Write Efficient Custom Queries: If using a custom query, avoid SELECT *. Only pull the columns you actually need. Use WHERE clauses to limit the date range or filter data on the BigQuery side before it gets to Looker Studio.

3. Data Not Showing Up-to-Date

The Problem: You know there's new data in your BigQuery table, but your Looker Studio report is still showing old information.

The Fix: Looker Studio caches data to improve performance. The default caching setting for BigQuery is 12 hours. You can change this by editing your data source, going to the top of the field list, and clicking on Data freshness. You can set it to refresh as frequently as every 15 minutes.

Final Thoughts

Connecting Looker Studio directly to BigQuery gives you a business intelligence powerhouse, capable of analyzing huge volumes of data and presenting it in clean, interactive reports. Following the steps above, you can confidently link your data warehouse to your visualization tool and begin uncovering valuable insights.

While direct connections like this offer a lot of control, sometimes the initial setup involving GCP permissions and navigating BI tools can feel like a steep climb for those of us who aren't data engineers. We built Graphed to remove this friction. With our platform, you can connect your various data sources directly and start building dashboards instantly just by describing what you want to see — no SQL or complex setup required.