Skip to main content

Tutorials｜How to connect BigQuery to Google Cloud Platform and Looker Studio

  • Updated

    This guide is designed for customers who wish to query Crescendo Lab data using BigQuery. You can follow this tutorial even if you are unfamiliar with Google Cloud Console or Looker Studio.

     

    # Ensure You Have Access to BigQuery

    If you need access to Google BigQuery, please contact Crescendo Lab's customer support team. We will assist you with the application process.

    ✅ If you also require access to GCP or Looker Studio, please provide the Gmail address you intend to use. We will enable the necessary permissions for that account.

     

    Once your application is approved, you will receive the following:

    • A designated Google service account (e.g., cresclab-bot@cresclab-partnership.iam.gserviceaccount.com)

    • A specific GCP project name (e.g., cresclab-prod)

    • Shared dataset ID (e.g., shared_dataset_1)

    • Permission to query the data

    • Gmail access to the project folder in GCP or Looker Studio

     

    # Access to BigQuery on the Google Cloud Platform

    1. Open https://console.cloud.google.com.

    2. Login with the Google account which has access to the project folder in GCP or Looker Studio (not the Google service account like cresclab-bot@cresclab-partnership.iam.gserviceaccount.com)

    3. Change the project

     

    4. Select the project you like to access to 

     

    5. Click the icon to open the menu

     

    6. Select "BigQuery" and "Studio"

     

    7. Then, you can access to the BQ database! You can access and organize your MAAC event by using SQL.

     

    8. You can enter any SQL query into the tables in the BigQuery database.

    For example, enter the query in the edit box and click 'run.' The result will be displayed at the bottom.

     

    9. You can also view the table's details by selecting the table directly on the left.

     

    # Connecting Looker Studio with BigQuery

    1. Open https://lookerstudio.google.com/.

    2. Login with the Google account which has access to the project folder in GCP or Looker Studio (not the Google service account like cresclab-bot@cresclab-partnership.iam.gserviceaccount.com)

    3. Create a data source and select BigQuery

     

    4. Select BigQuery

     

     

    5. Authorize BigQuery

     

    6. Select the project and dataset Crescendo Lab provided and click 'connect.'

    Please confirm that you have received all the information you need. Ref:

    Select the 'GCP project id' as the project, the 'shared dataset id' as the dataset, and the table to which you want to build visualization on Looker. 

     

    7. Customized the table, including data type, metrics, fields, and table refresh time. Then, create the report. 

     

    8. Start to create any visualizations and explore your data!

     

    # FAQ

    Q: Why can’t I find Crescendo Lab's project in GCP?

    A: Please ensure you are signed in to GCP using the Gmail account granted access by Crescendo Lab. If you’re unsure whether your account has access, please get in touch with our Customer Success Team for assistance.

     

    Q: Why am I seeing an “Access Denied” error in GCP or Looker Studio?

    A: Please get in touch with our Customer Success Team. We will help you review your permission settings and resolve the issue.

    Related articles