Share via

ERROR [28000] [Microsoft][BigQuery] (8706) Unable to open keyfile

Stefani 21 Reputation points
2022-11-21T17:23:29.167+00:00

I'm trying create a Big Query Linked Service, but it returns the following error in the connection test: 262772-captura-de-tela-2022-11-21-141900.png

I know that the file needs to be a .json extension and be in the /C: directory, but I've already done all that. What can I do to get it?

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
9,105 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,682 questions
0 comments
Accepted answer
  1. ShaikMaheer-MSFT 38,551 Reputation points Microsoft Employee Moderator
    2022-11-22T06:44:37.437+00:00

    Hi @Stefani ,

    Thank you for posting query in Microsoft Q&A Platform.

    I hope you are using Google BigQuery connector here. if not, kindly share more details on it.

    For Google BigQuery connector when we use service authentication we need to provide keyFilePath details. Here we should use full path to the .p12 or .json key file that is used to authenticate the service account email address.

    One thing to observe here, is we need to have this file on IR machine and from that IR machine we should take full path and use same. Could you please recheck is key file available on machine at right location? If yes, could you please share more details and screenshots of your linked service configurations and key file path details from IR machine?

    Please let me know how it goes. Thank you.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.