This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 39%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
We have a problem scanning BigQuery in Microsoft Purview.
All settings are done according to the documentation. But after starting the scan, an error appears: "Error: (3805) Connector Exception: Cannot access any schema in the database.".
The BigQuery service account is allowed access to the project as owner.
Please, advise in what there can be a problem?
Hi Dmitrii D ,
Thankyou for using Microsoft Q&A platform and thanks for posting your question here.
I have approached the internal team to get information about the error you are facing. I will revert back once I hear back from them . Thankyou for your patience.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 32%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Hi, please post some screenshots of your scan configuration screen. Without that it will be tough to comment on the issue.
When does Purview plan to support scanning of the EU region?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 81%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Hello,
I am trying to scan in Microsoft purview, but am getting with following error, could you please guide me further. In googleBigquery am using service account and I have selected region as US.
Hello,
I am trying to scan in Microsoft purview, but am getting with following error, could you please guide me further. In googleBigquery am using service account and I have selected region as US.
I added a service account to BigQuery and gave access to the project.
Read-only access to all schemas in one of our projects. Also I gave the owner access to one schema.
I found the reason for the failed BigQuery scan.
Currently, Microsoft Purview only supports scanning Google BigQuery datasets in US multi-regional location. If the specified dataset is in other location e.g. us-east1 or EU, you will observe scan completes but no assets shown up in Microsoft Purview.
After changing the region in the schema, I re-ran the Purview scan. As a result, I got the entities in the data catalog.
Hi Dmitrii D ,
Thanks for sharing the insights regarding the issue cause and its resolution.
Hi, please post some screenshots of your scan configuration screen. Without that it will be tough to comment on the issue.
Dmitrii D , Thankyou for sharing the required information with screenshot .
Could you please help here? Thankyou for your assistance.
My Service Account has Data Owner permission in Schema our project.
Do you have any ideas what could be the problem?
My Service Account have Data Owner permission in Schema our project.
Do you have any ideas what could be the problem?