I would like to know how to link Big Query's query and LookerStudio

Google Cloud Data Analytics
1

How can I link Big Query’s query and Looker Studio that is protected by VPC?

The VPC configuration is as follows
ingress rule : ANY_IDENTITY, ANY_Service Account, BigQuery API
egress rule : ANY_IDENTITY, ALL Projects

I am working with BigQuery and Looker Studio.
Looker Studio is updated every 15 minutes.
It runs correctly in my office, but I get errors in network environments outside of my office.
The following message error.

Service control error
Your organization’s VPC Service Controls prohibit access to the datasets used by this component.

Access Context Manager allows office networks, but not non-office networks.
My guess,

  1. IP permission by Access Context Manager
  2. Creation of a service account for Looker Studio to perform queries
  3. Allow Looker Studio in the VPC
    I believe one of the above needs to be addressed…

I would be glad if you could suggest a solution.

2

Hi @km2 ,

Thank you for reaching out to our community.

You are experiencing one of the benefits of a VPC Service Control, securing your data from unauthorized access outside your service perimeter.

Access from the internet to managed resources within a service perimeter is denied by default. Optionally, you can enable access based on the context of the request. To do so, you can create ingress rules or access levels to permit access based on various attributes, such as the source IP address, identity, or source Google Cloud project.

Explore this design access levels document to understand which one works for you. As you initially thought, granting access based on source IP is one way to go, you can also set up Ingress rules to allow access to your device via the internet.

Ingress: Refers to any access by an API client from outside the service perimeter to resources within a service perimeter.

Adding this VPC Service Controls support for Looker document for your reference. You can also reach out to VPC Service Controls Support for detailed assistance.

Hope this helps.

3

Hi! lsolatorio

Thank you for your answer!
I have BigQuery set up within a boundary and I have a schedule set up in a connected sheet.

I can’t seem to get it to work, but I will give it a try based on your article.
Please let me know if anything else comes up that I don’t understand.

Thanks for the reference.